Need db expert in answering easy question like ERD
Final Project:
1. Cover page with your name and your project title.
2. Description of your database application.
3. 6-8 User Views ( reports that contain data from the new database you are planning to build ) with titles.
make certain you add some data in your views (reports). You will be designing your tables based on
these user views.
4. Normalization to 3rd normal form (3NF) of each view.
5. Merged view containing table names, their primary keys and attributes.
6. ER-Diagram with max and min cardinality.
7. a readme.txt file, explaining how to implement your project.
8. SQL files that creates your database application that I can run. It should have a createTablespace.sql file that I can run to create your tablespace for all your files for your application. It should contain a
sql file that allows me to create all your tables and the 6 reports, taking data from multiple tables.
9. 6 SQL files that creates each user views with SELECT statements.
Zip all these SQL files along with your readme text file.
note: if steps 1-6 is done as word documents or pdf documents, zipped them with the sql files.
If not, turn in your paper work for steps 1-6 on Tuesday night when the project is due.
9. Include any business rules you may have applied in constraints.
10. Add additional documentation to further explain your work if needed. Even if your