Purchase Solution

Normalisation of Database Design

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.