Question: Description: You have been hired by Amazon to create a database that will incorporate all the features below: Drones: Drone information is captured including a
Description: You have been hired by Amazon to create a database that will incorporate all the features below: Drones: Drone information is captured including a unique ID number, manufacturer, miles flown, top speed (in miles per hour), carrying capacity (in pounds), run time (in minutes), and battery type. Customers: Individuals are assigned a unique Customer ID number. This information along with their name, address, phone number, gender, birth date, and date of prime membership are recorded. Orders: Each order includes the customer id, drone delivery id, product name, price, place of delivery (home, business), and promotion. Develop the three Database tables for the above in Access (note: Access software can be found in the lower level LBC lab and through vlab.stetson.edu, this creates a virtual connection to the Stetson computer labs, contact the helpdesk 386-822-7217 to help login/setup as needed) Paste Screenshots below for each of the table designs from Access (PrtScn -> Paste, Mac: Cmd+Shift+4) Table Design View 1. 2. 3. Enter a sample data record for each table, paste screenshots below for each of the sample records. Table Datasheet View 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
