Update the initial database to include six additional tables

Assignment Help Database Management System

Reference no: EM131598741

Assignment

Update the database that you created in Unit 3 to include the following tables:

Using the following diagram that represents the initial seven tables, establish relationships between the tables and specify primary and foreign keys in your database. Perform this activity for the other tables in your database as well. There should be a total of sixteen tables overall.

Using the diagram, address the following:

• Update the initial database to include six additional tables as shown in the first diagram.

• Define the relationships between the tables in the SQL server environment.

• Ensure that all primary keys are properly created and that the foreign key columns are defined correctly.

• Make sure that the 3 additional tables you added in Unit 3 are also shown and have established relationships and their primary and foreign keys.

• Update the database diagram, and generate the data definition language (DDL) for all 16 tables.

• Submit a consolidated Word document with all screenshots and the DDL.

Reference no: EM131598741

Questions Cloud

Emergency medical treatment and labor act : Select a healthcare related policy - The Emergency Medical Treatment and Labor Act (EMTALA) - prepare an analysis explaining its purpose and impact.

Compute the return on common stockholders equity : Compute the return on common stockholders equity. (Round answer to 1 decimal plac, e.g. 10.5%) Return on common stockholders equity is what

Was lincoln a racist : President Abraham Lincoln is usually remembered as a staunch abolitionist who ended slavery. However, historians have debated whether or not Lincoln truly.

Discuss the various kinds of ratio analysis categories : Discuss the various kinds of ratio analysis categories and briefly explain what information is gathered from their calculations

Update the initial database to include six additional tables : Update the initial database to include six additional tables as shown in the first diagram. Submit a consolidated Word document with all screenshot and the DDL.

Why would a positive test for decarboxylase : Why would a positive test for decarboxylase (purple and not cloudy) would effect your interpretation of the results?

What is or are the premises : What is or are the premises?Is this a good argument? What's misleading about it? Where is the reasoning mistake?

Because of its thin cell wall : The acid-fast bacterium, M.smegmatis, is relatively safe for students to work with because of its thin cell wall.

Explain the difference between nominal and ordinal data : Explain the difference between nominal and ordinal data - Explain how nominal and ordinal data relate to a rating scale.

User Account

All Pages