[Solved]Design Relational Database Tables Fields Relationships Situation Department Wants Create D Q37184185

Design a relational database (just the tables, fields, andrelationships) for this situation:

IT department wants to create a database that keeps track ofequipment throughout the company. They need to know which employeehas what equipment and location of equipment (if in office, whichone. if in shared areas, which department). They also need to knowspecs about each piece of equipment–year bought, description,platform (if appropriate).

Indicate primary and foreign keys and how they relate to eachother

Expert Answer

---

Answer to Design a relational database (just the tables, fields, and relationships) for this situation: IT department wants to cre… . . .