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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started