Question: Can you please help me with this database assignment ? Draw an Entity-Relationship diagram(including cardinality ratio and participation constraint) to represent the following application: A
Draw an Entity-Relationship diagram(including cardinality ratio and participation constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affiliated only with one DEPARTMENT: A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT: on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. A trucking company is responsible for picking up shipments for warehouses of a retail chain and delivering the shipments to individual retail store locations. A truck may carry several shipments during a single trip, which is identified by a Trip#, and delivers those shipments to multiple stores. Each shipment is identified by a Shipment# and include data on shipment volume, weight, destination, etc. Trucks have different capacities for both the volumes they can hold and the weights they can carry. A database is being designed to keep track of truck usage and deliveries and to be used for scheduling trucks to provide timely deliveries to stores. Design an ER schema diagram for the above application. Make any assumptions you need but state them clearly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
