Question: Mall Database Relations Employees( eid: integer, name: String, position: String, salary: double ): 15] Employs( store: String, eid: integer): [201 Stores(name: String, location: String ):

 Mall Database Relations Employees( eid: integer, name: String, position: String, salary:

Mall Database Relations Employees( eid: integer, name: String, position: String, salary: double ): 15] Employs( store: String, eid: integer): [201 Stores(name: String, location: String ): [4] ltems( item: String, brand: String, price: double : 15] Inventory( name: String, item: String, quantity: integer ): [25] Customers(name: String, address: String, aid: integer ): [5] Transactions( tid: integer, store: String, item: String, customer: String, date: Date ): [30] balance: double, type: String ): 7; type must be one of credit, checking, or cash ] Exercises [15 pts] Modify the database Mall to use the relations given here. Note, these relations are based upon the solution to Hw #7, but they are slightly different. 1. [10 pts] Populate each table in the database with at least the number of tuples (record entries) given in the brackets following each relation. 2

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!