Question: Using MS-Access, you need to create a new database for managing person's devices such as phone, computer, tablet, etc. You can just do the same

Using MS-Access, you need to create a new database for managing person's devices such as phone, computer, tablet, etc. You can just do the same way as you did in class exercise with MS-Access. Submit to Blackboard: "Labs rightarrow Lab6 - Database (MS-Access) Part 1" folder Points allocated for this assignment: 7 out of 22 points for DB & Analytics Assignments Due date: Next Week (See Blackboard) You should create a new database that satisfies the following requirements: Your database is used to manage devices (e.g., laptop, phone, tablet, PC, and the like). It has two tables named Owner and Device. Owner table has at least the following attributes: Owner_ID, Owner Name, Phone_Number, Address. Device table has at least the following attributes: Serial_Number, Device Name, Type_of_Device, Owner_ID (as a Foreign Key). You can add additional attributes for the tables (optional) if you want. You need to define a primary key for each table. You should create a relationship between these two tables using a foreign key. Insert some data into both tables: at least 3 people for Owner table, and 5 devices for Device table. Save the MS-Access file and submit it to Blackboard
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
