Assignment No. 01
SEMESTER Spring 2018

CS403- Database Management System

 

Total Marks: 20

 

Due Date: 14/05/2018

Instructions

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 instructions

Your submission must include:

 

  • Assignment should be in .doc or .docx format.
  • Save your assignment with your ID (e.g. bx020200786.doc).

Assignment submission through email is NOT acceptable

Objective

The objective of this assignment is

o   To give basic knowledge and understanding of Database.

o   To be able to understand Conceptual Database Design.

 

Note:

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

Deadline

Your assignment must be uploaded/submitted at or before 14/05/2018.

 

 

 

 

 

Question  

 

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.

 

 

 

 

=====================================Ended=======================================

 

For any query about the assignment, contact at CS403@vu.edu.pk

 

GOOD LUCK

 

Views: 1210

Attachments:

Replies to This Discussion

also need

cs403 solution plz

ye lo solution 

jazakALLAH Khair for sharing :)

Here Is The Solution 

Attachments:

jazakALLAH Khair for sharing :)

sol file is attach

Attachments:

RSS

SPONSORED LINKS

© 2018   Created by Muhammad Anwar Tahseen.   Powered by

Badges  |  Report an Issue  |  Terms of Service