Question: Instructions: For the problems in this Individual Assignment, you can work in group to solve the model collectively. After that, the MySQL model needs to

 Instructions: For the problems in this Individual Assignment, you can workin group to solve the model collectively. After that, the MySQL model

Instructions: For the problems in this Individual Assignment, you can work in group to solve the model collectively. After that, the MySQL model needs to be built and submitted individually For submitting on Canvas, do not upload your MySQL file. Take screen-prints of your solution from MySQL and paste them into a consolidated word document to submit. Screen-print instructions: Do not take a whole screen image. Zoom in to just capture the model so that it can be read clearly Ensure that the Indexes arrow is expanded in your MySQL model so that the Primary and Foreign Keys are visible clearly. O Problem 1: The following table shows the EER diagram for a Bank: CUSTOMER Customer ID Cust Name Cust Address Holds CARD ACCOUNT Account ID Exp Date Card Type MERCHANT Merch ID Merch Addr Card Type = d "D" DEBIT CARD Bank No CREDIT CARD Cur Bal CHARGES Charge Date Charge Time Amount Convert this to a relational schema in the text notation showing all Primary keys, Foreign Keys and other attributes for each relation. (Hint - do you see that CHARGES is an Associative entity type created due to a many-to-many relationship between CREDIT CARD and MERCHANT?)

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!