Question: Consider a system that needs to store information about computers in a computer lab at a university, such as the features and location of each

Consider a system that needs to store information about computers in a computer lab at a university, such as the features and location of each computer. What are the things that might be included in a model? What are some of the relationships among these things? What are some of the attributes of these things? Draw an entity- relationship model for this system

Please Include "One to many" or "Many to many" etc. lines. Also, please provide any notes of what you did throughout the ERD diagram. Please include that note on the side.

I need at least 4 boxes!

The lines must look like this: Example...

Consider a system that needs to store information

Asset Types PK asset_type_code asset_type_description IT Assets PK FK Employee Assets Employees asset_id asset_type_code description other details FF FF FK asset_id employee.id date out date returned condition.out condition_returned other details PK employee_id first name last name department extension email address other details IT Asset Inventory PK it_asset_inventory_id FK asset_id inventory.date number assigned number_in_stock other details

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!