Directions: Write the answer to a question on this document immediately following the question. Write Oracle SQL when SQL is required. Do not provide SQL commands on this document. Submit SQL in separate files.
I will execute all the Oracle commands or scripts submitted to verify correctness and completeness. All SQL commands and scripts must execute correctly without error/. include descriptive explanations, steps and/or documentation on how you accomplished the tasks given.
1. Question 1 requires you to design a database that is in at least third normal form (3NF). The database will store and maintain credit card statement information.
a. Use Oracle SQL Data Modeler to create your relational data model. For each table show the primary key and show any foreign key dependencies between the tables. Place a graphic of your data model in the space that follows.
b. Explain why the database schema in (a) is in third normal form (3NF) in the space that follows.
c. Submit the DDL of the database. Include primary key and foreign key constraints. Name the file FinalQ1.sql
d. Provide three references and describe how you used them to complete parts (a) and/or (b).
2. Question 2 requires you to create an object-relational Oracle database for a Bill of Materials for a bicycle. Review a bicycle BOM included. Review a relational BOM "simple model".(included)
a. Use any technique to create the DDL for the database. Describe the technique or tool you used to create the DDL for your database in the space that follows.
b. Describe object-relational components of your database in the space that follows.
c. Submit the DDL of the database. Include primary key and foreign key constraints. Name the file FinalQ2.sql.
d. Provide three references and describe how you used them to complete parts (a) and/or(b).
3. Review the Corporate Organizational Chart below and represent it as a NOSQL database.
Figure 4
a. Describe the NoSQL database you selected to represent the Corporate Organizational Chart in the space that follows. Include your rational for the selection.
b. Provide a representation of the NoSQL database you selected in (a) in the space that follows.
c. Provide three references and describe how you used them to complete parts (a) and/or (b).