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

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

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 Databases Questions!