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.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
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 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 are assigned to the case by the presiding judge for that court. The cases remain
active until the court passes the final judgement on it.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY