CS403 Assignment No 1 Solution Spring 2018

CS403 Assignment No 1 Spring 2018

Dear Students, Here you can read or Download CS403 - Database Management System Assignment No 1 Solution and Discussion of Semester Spring 2018. Assignment Due Date is 14 MAY, 2018. Total Marks are 20. This assignment covers lesson no. 1-10. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. CS403 Assignment Solution File has been added. Previously we shared CS403 Current Mid Term Paper Fall 2016.

CS403 Assignment No 1 Solution and Discussion Spring 2018

CS403 Assignment Instructions

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit if:

The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted in .doc or .docx format.

CS403 Assignment 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

CS403 Assignment Objective

The objective of this assignment is :

To give basic knowledge and understanding of Database.
To be able to understand Conceptual Database Design.

Please 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.

CS403 Assignment Deadline

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

Assignment Question No 1:

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.

Assignment Tasks:

Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.

Please Note: You are required to submit ERD as your solution only.