[go: up one dir, main page]
Scribd
Upload
204 views3 pages

ER Diagrams for Database Systems Assignment

The document outlines an individual assignment for a course on Fundamentals of Database Systems at the University of Juba, due on 27/11/2025. It includes two questions requiring the creation of ER diagrams based on specified scenarios involving companies, departments, employees, dependants, suppliers, products, and buyers. Students are instructed to handwrite their submissions and warned against plagiarism.

Uploaded by

tempomayek0
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
204 views3 pages

ER Diagrams for Database Systems Assignment

The document outlines an individual assignment for a course on Fundamentals of Database Systems at the University of Juba, due on 27/11/2025. It includes two questions requiring the creation of ER diagrams based on specified scenarios involving companies, departments, employees, dependants, suppliers, products, and buyers. Students are instructed to handwrite their submissions and warned against plagiarism.

Uploaded by

tempomayek0
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

UNIVERSITY OF JUBA

School of Computer Science and Information Technology

Course name: Fundamentals of database system

Instructions:

1. Individual assignment
2. Handwritten
3. Submission date 27/11/2025
4. Time 10:00 AM
5. Copy and paste you get yourself zero (0)

Question 1
Create an ER diagram for each of the following descriptions:
(a) Each company operates four departments, and each department belongs
to one company.
(b) Each department in part (a) employs one or more employees, and each
employee works for one department.
(c) Each of the employees in part (b) may or may not have one or more
dependants, and each dependant belongs to one employee.
(d) Each employee in part (c) may or may not have an employment history.
Each company has a name and a companyID. Each department has a name
and a department ID. Each employee has a firstname, lastname,
telephone,email. Each dependant has firstname, lastname and address.
employee history is tracked by the company name, years spent and position
held. Represent all the ER diagrams described in (a), (b), (c), and (d) as a
single ER diagram.
Question 2. Draw an ER diagram to represent the scenario below. Clearly
show all the primary and foreign keys
A supermarket sells many products. Each product is tracked by a name,
productID and price. Product are supplied by suppliers. Each supplier is
tracked by their firstname, lastname, telephone and address. Suppliers are
also given a supplierID which is auto-increment. A supplier can supply many
products and each product can be supplied by many suppliers. Products are
bought by buyers. Buyers are tracked by their firstname, lastname,
telephone. Buyers are also given a buyerID which is auto-increment. A buyer
can buy many products at a time. We need to know which supplier supplied
which products and the quantity that they supplied. We need to know which
buyer bought which products and the quantity that they bought.
GOOD LUCK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

You might also like