Reference no: EM13697

I. Describe the application that you would like to design. This should include the purpose of the application and an informal description of the application functionality. List and describe in detail the data elements that must be captured in this application and stored in the database. The application may meet all of the data needs of a business or may be specific to a single need within that business.

II. Add "use cases" for your database. In this case, all you need is several questions that you would use your database application to answer. These should be Select queries and not database updates or other database manipulation statements.

III. Draw one or more Entity-Relationship diagrams for database.

IV. Prepare the relational schema for your database based on your E-R diagram. Then revise this schema to be normalized or, if you choose not to, Describe why denormalized tables are preferable. Implement this in your Oracle or MS SQL Server database and populate the database with test data. Project contains:

a. the ERD

b. the relational schema (not CREATE TABLE statements)

c. a description of the normalization of these tables

d. the data definition statements that you used to create the tables;

e. a sample of the statements for inserting data into the tables (two or three for each table will do);

V. Write the SQL queries that support at least three of your use cases. Perform a screen capture showing the results when you run these queries against your database. Please edit the screen capture to delete all unnecessary text so that this will be legible to your readers. Finally, add a conclusion that briefly sums up the project and any ideas you have for implementing it.