For the final project, you will design and implement a database of your choosing consisting of 8
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 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.
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George