Question: Create database tables and queries: Name the database with your last name first initial Create three tables with the following specifications. Customers Table ( 5

 Create database tables and queries: Name the database with your last

Create database tables and queries: Name the database with your last name first initial Create three tables with the following specifications. Customers Table ( 5 points) Include the following fields a) Customer ID (make the primary key) b) Lname (for last name) c) Fname(for first name) d) Address e) City f) State g) Zip h) Phone Orders Table (5 points) Include the following fields a) OrderID (make the primary key) b) CustomerID c) BookID d) Order Date Books Table (5 points) Include the following fields a) BookID (make the primary key) b) Title c) Author FName d) Author LName e) Price f) Category Customers table, the CustomerID field (primary key) should have the same data and data type in it as the CustomerID field (foreign key) in the Orders table. (5 points) 2. Make sure the correct data type is used for each field name (such as short text, number, or date, etc..) (5 points) 3. make sure Cascade update related fields and Cascade Delete related records boxes are checked. (10 points) 4. field names in the table in the query.) Save the query with the name CustomersbyState ( 5 points)

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 General Management Questions!