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 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
Get step-by-step solutions from verified subject matter experts
