Virtual University of Pakistan Study forum !
Assignment No. 01
CS403- Database Management System
Total Marks: 20
Due Date: 14/05/2018
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
o Student ID is not mentioned in the assignment File or name of file is other than student ID.
o The assignment is not submitted in .doc or .docx format.
Uploading instructionsYour submission must include:
Assignment submission through email is NOT acceptable
The objective of this assignment is
o To give basic knowledge and understanding of Database.
o To be able to understand Conceptual Database Design.
Your answer must follow the below given specifications.
· Font style: “Times New Roman”
· Font color: “Black”
· Font size: “12”
· Bold for heading only.
· Font in Italic is not allowed at all.
· No formatting or bullets are allowed to use.
· Your answer should be precise and to the point, avoid irrelevant detail.
Lectures Covered: This assignment covers Lecture # 01 - 10
Your assignment must be uploaded/submitted at or before 14/05/2018.
Trend of celebrating events in Pakistan is changing rapidly. People got more conscious about the event related arrangements. They spend more time, energy and money to make their events memorable and different from others. Event planners are hired to make events more organized, memorable and ostentatious. “Traditions” is a newly established event planning company.
“Traditions” covers weddings functions, birthday parties and corporate meetings. Customers have to get registered before placing order. Customer has to select the desired venue according to the category of function. Customer can select only a single venue for a function. Company is also offering other services like catering, stage decoration etc., for the events. Customers select the menu and catering while placing order. Menu has many food items.
The entire application is going to be developed in the broad perspective, However you are required to keep in view only the scenario (portion) whose details have mentioned above and perform the following tasks.
· Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.
Note: You are required to submit ERD as your solution only.
For any query about the assignment, contact at CS403@vu.edu.pk