Question
For the final project, you will design and implement a database of your choosing consisting of 8 to 10 related tables. Your completed design will
For the final project, you will design and implement a database of your choosing consisting of 8 to 10 related tables. Your completed design will be a fully normalized (3NF) database with appropriate table and field names, data types, constraints, default values, indexes, sample data, and views supporting end-user use of the database for forms and/or reports. Each table must have a relationship with at least one other table, and no one-to-one relationships are accepted.
If you have any concerns regarding the database you have chosen to implement, or need guidance in selecting a project, please contact the instructor before proceeding.
In Part 1 I need to create the normalized logical design for your database (table and field names). Your logical design may include an E-R diagram or PascalCase if you prefer.
In Part 2 I need to create the physical design for your database (tables, fields, relationships, constraints, default values, and indexes).
In Part 3 you will populate your database with sample data and create views to support end-user use of the database for forms and/or reports. Each table must have a minimum of three records of sample data. Each table must be represented somewhere within the completed views. Each view must include joins correctly linking the included tables and must show sample data when run.
In Part 4 you will record a 3-5 minute presentation demonstrating and explaining your database design.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started