Explore BrainMass
Share

Normalisation of Database Design

Normalize the tables you have designed in module 2. Explain how you redesign your tables to satisfy the requirements of 1NF, 2NF and 3NF. When necessary, it is perfectly okay to create another table. If you believe your tables designed in module 2 already met the normalization requirement, explain why.
Modify the database you created in Module 3: drop the tables that you have redesigned for normalization, and keep those that are intact.
Create new tables as required in your new design, using SQL in DBMS.
Include the SQL statements and screenshots of your new tables in the paper.

SLP assignment expectations
Create tables that met normalization standards.
Use SQL to create and drop tables.

© BrainMass Inc. brainmass.com August 20, 2018, 8:16 am ad1c9bdddf

Attachments

Solution Preview

Normalize
SLP assignment
In this assignment, you are to use what you have learned about normalization to improve Trident Student database design. Following are your tasks:

Normalize the tables you have designed in module 2. Explain how you redesign your tables to satisfy the requirements of 1NF, 2NF and 3NF. When necessary, it is perfectly okay to create another table. If you believe your tables designed in module 2 already met the normalization requirement, explain why.
Modify the database you created in Module 3: drop the tables that you have redesigned for normalization, and keep those that are intact.
Create new tables as required in your new design, using SQL in DBMS.
Include the SQL statements and screenshots of your new tables in the paper.

SLP assignment expectations
Create tables that met normalization standards.
Use SQL to create and drop tables.


Solution
Course Table:
Course Information
CourseID Title Room# Professor Credits
ITM432 Principles of Finance and Financial Information Systems 312 Johnson 4
ITM433 Computer-Human Interaction, Groupware, and Usability 310 Williams 4
ITM434 Business Ethics and Social Issues in Computing 250 Washington 4
ITM435 Marketing and Marketing Information Systems 225 Jefferson 4
ITM436 Operations ...

Solution Summary

This solution takes a step by step approach to explain how database tables are created and normalized. It also shows the SQL statements constructed to manipulate data for reading, inserting, and updating purposes.

$2.19