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