Posted: June 2nd, 2021

Assignment 7 – e-r model work

we have developed the E-R model for the Highline University database. See below for a copy of the final data model (created in MS Visio) we developed in class. After you have reviewed the E-R model, create a relational database design for the model. 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
  1. For each entity in the E-R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables. Refer to the metadata table of Figure 5-26 on page 312, Chapter 5 in the textbook as a guide for format to document detailed column properties.
  2. Document referential integrity constraint enforcement actions and any business rules that you think are important. Use the provided RI table template below to fill in as appropriate (similar to part of your team project D3 requirements). You can also refer to Figure 5-29 on page 317, Chapter 5 in the textbook for an example.

Assg7.jpg

Note: Use the following referential integrity table template for question 2 of the assignment.

Relationship

Referential Integrity Constraint

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Cascading Behavior

PARENT

CHILD

 

ON UPDATE

ON DELETE

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
error: Content is protected !!
Open chat
1
Order through WhatsApp!
affordablepaperwritings.com
Hello!
You Can Now Place your Order through WhatsApp
 

 

Order your essay today and save 30% with the discount code DISCOUNTS2022