Question: 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

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. An example credit card statement is illustrated on this web site: www.mycreditunion.gov/Pages/pocket-cents-understanding-credit-card-statement.aspx

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. Provide three references and describe how you used them to complete parts (a) and/or (b).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!