Question: Propose a design of your database system. Your database must be applicable to a real world scenario. Your design must meet the third normal form,
Propose a design of your database system. Your database must be applicable to a real world scenario.
Your design must meet the third normal form, and you should strive to achieve the best possible design.
Cover page that shows the course name, student name, instructor name and date. (10)
oProject Description (30)
Describe the purpose, nature, applicable environment, or any other details about your project. (20)
List the users and their relevant access rights. (10)
oProject Design (40)
Describe the design ideas of your tables, data and relationships. This includes:
The purpose for each table(10)
Table structure descriptions, e.g. STUDENT(ID, LastName, FirstName, Adviser, ...)(10)
Field definition for each table(10)Relationship description (10)
Include anything else necessary to explain, support or rationalize your design. oAn ER diagram that shows an overview of the design. (20)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
