Instruction: For each question posted below please solve and post the answers differently so that I would be able to navigate which question was solved Question Create Conceptual Models using Draw.io for the following case descriptions: Use a Draw.io blank drawing, and add the relationships from the ER diagram templates group in the left side panel. Create the three conceptual data Models using Draw.io, export these models as Jpegs, and then add all three models in an MS Word document and submit that MS Word file with all three images (of data models in it) through Blackboard submission link before the deadline. 1. You have been asked to design a database that would store data for ABC Company, which is a small online retailer. ABC would like to
Instruction:
For each question posted below please solve and post the answers differently so that I would be able to navigate which question was solved
Question
Create Conceptual Models using Draw.io for the following case descriptions:
Use a Draw.io blank drawing, and add the relationships from the ER diagram templates group in
the left side panel.
Create the three conceptual data Models using Draw.io, export these models as Jpegs, and then
add all three models in an MS Word document and submit that MS Word file with all three images
(of data models in it) through Blackboard submission link before the deadline.
1. You have been asked to design a
is a small online retailer. ABC would like to store data about its customers, orders, items,
couriers. Each customer may place multiple orders. An item may be part of many orders
and order typically contains multiple items. Each order is shipped via one of the
couriers (parcel companies) and ABC Inc. has contracts with several couriers for shipping
its customer orders.
2. ABC College has many departments and each department offer courses. Some popular
courses have many course sections. Each Faculty member belongs to a particular
department and may teach more than one-course sections of a course, but in some
semesters a faculty member may not teach any. Each course section must have at least
one faculty number teaching it, but sometimes multiple faculty members teach a course
section. Furthermore, to make sure that all course sections are similar, one faculty
member is assigned as course coordinator to oversee the course, and each faculty
member may coordinate many courses. Students may enroll in many course sections and
receive a grade at the end of the term for every course that they have enrolled in.
3. An Attorney is retained by one or more clients for each case and each case can also be
filed by many clients collectively (class action?). Sometimes a team of attorneys is assigned
to a case by the Managing Partner in the firm. Each client, case, and attorney is identified
by a unique id and you can assume other attributes to represent these entities. Each case
is heard by one and only one court but a single court can hear many cases from this law
firm. Each court has one or many judges assigned to it but one judge works only in one
court. Normally one judge hears a particular case but sometimes for bigger cases a bench
of judges is assigned to the case by the presiding judge for that court. The cases remain
active until the court passes the final judgment on them.
Step by step
Solved in 3 steps with 1 images
