Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Databases questions

Question

L 2 which has an odd number of bs and an even number of as .

Answered: 1 week ago