CS403 DBMS - Fall 2019 Assignment 01: Context & ER Diagrams, Assignments of Computer Science

The context level diagram and entity relationship diagram (erd) for a database management system project in the cs403 course, which is focused on database management systems. The diagrams illustrate the relationships between various entities such as customer, salesman, order, delivery, update, status, feedback, pay, dues, bill, manager, employee, discount, water, dispencers, work, and bottle details. Students are expected to use this information to design and implement a database system.

Typology: Assignments

2019/2020

Uploaded on 10/26/2020

unknown user
unknown user 🇵🇰

2 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Manager
Customer
Company
Assignment No. 01
SEMESTER Fall 2019
CS403- Database Management System
YOUR NAME
YOUR ID
Context Level diagram:
Entity Relationship Diagram (ERD):
CUSTOMER
ID
NAME
ADDRESS
SALESMAN
ID
NAME
SALARY
ORDER
DELIVERY
UPDATE
STATUS
FEEDBACK
PAY
DUES
ORDER
REQUEST
STOCK
ORDER
REQUEST
BILL
MANAGER
ID
NAME
SALARY
EMPLOYEE
ID
NAME
SALARY
DISCOUNT
+
WATER
DISPENCERS
WORK
DETAILS
WATER BOTTLE
NAME
COMPANY
NAME
Check Orders Take Orders
Salesman
DBS
Bill Update Orders
Deliver Order
Pay Dues
Request Stocks
Details
Work Feedback
Bottle Details
Employee

Partial preview of the text

Download CS403 DBMS - Fall 2019 Assignment 01: Context & ER Diagrams and more Assignments Computer Science in PDF only on Docsity!

Manager

Customer

Company

Assignment No. 01

SEMESTER Fall 2019

CS403- Database Management System

YOUR NAME

YOUR ID

Context Level diagram:

Entity Relationship Diagram (ERD):

CUSTOMER

ID

NAME

ADDRESS

SALESMAN

ID

NAME

SALARY

ORDER

DELIVERY

UPDATE

STATUS

FEEDBACK

PAY

DUES

ORDER

REQUEST

STOCK

ORDER

REQUEST

BILL

MANAGER

ID

NAME

SALARY

EMPLOYEE

ID

NAME

SALARY

DISCOUNT

WATER

DISPENCERS

WORK

DETAILS

WATER BOTTLE

NAME

COMPANY

NAME

Check Orders Take Orders

Salesman

DBS

Bill (^) Update Orders

Deliver Order Pay Dues

Request Stocks Details

Work Bottle Details Feedback

Employee