Mis

You are asked to create a database containing information about cars in different showroom. Save the database as (your student ID-your first name) in the Blackboard (Assignmet-2). Note: This is an individual assignment. 1. Create and save each of the following tables: Showroom Car Notes: a Specify the data type and field size of each field. b Ensure that the Car price is more than 100 by writing a validation rule and the appropriate validation text for it. 2. Create the relationship between the tables based on the following business rules by drawing the relational diagram using Access: a Save the diagram. Open each table and insert the appropriate data. Bookstore-your student IDCar XYz NGF Dubai Book-your student ID Car make Car BMW while 017 30k 200k 270k BMW black 5. Create the following queries: a. Display the Car make, and Car model for cars which are found in Showroom no-112. Save the query as Query-1 b. What is the number of cars in each store? Display the Showroom no and the number of cars. Save the query as Query-2 e. Display the Car make, and location for books which has price less than 200. Save the query as Query-3