Create your relational data model

Assignment Help Database Management System

Reference no: EM131947722

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.

993_No SQL.jpg

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).

Reference no: EM131947722

Questions Cloud

How does systemic risk differ from systematic risk : What is systemic risk? How does systemic risk differ from systematic risk? Why may one claim that when AIG was engaged in the CDS

Project cash flows equal its initial investment : The IRR is the discount rate that makes the present value of a project's cash flows equal its initial investment.

Complete bipolar and depressive disorders comparison chart : Directions: Although bipolar and depressive disorders share several key similarities, some aspects are radically different among these disorders.

Bypass ratio of the engine system : A contributing factor to an airplane's duel consumption is the bypass ratio of the engine system.

Create your relational data model : Create your relational data model. For each table show the primary key and show any foreign key dependencies between the tables.

Budgeting decisions are based on incremental cash flows : Capital budgeting decisions are based on incremental cash flows. When the internal rate of return is less than this required rate of return, the project is reje

How will impact the statutory remittance schedule : How will impact the statutory remittance schedule. Using the Current Year calendar in the course material, provide specifics of when the remittances

What is the firms earnings growth rate : They also stated the firm's return on equity is 16% percent. Airfoil retains 80% percent of their earnings. What is the firms earnings growth rate?

What is the current price : The dividends are expected to grow at a constant rate of 6% percent per year, indefinitely. If investors require a return of 8% percent

User Account

All Pages