Subject: CS403-DBMS
Semester: FALL 2018
Assignment No. 1
Total Marks: 20
Due date: 26 November, 2018
Instructions:
You need to use MS word document to prepare and submit the assignment on VU-LMS.
§ The assignment is not in the required format (doc or docx)
§ The submitted assignment does not open or file is corrupt.
Assignment is copied(partial or full) from any source (websites, forums, students, etc)
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
· To give basic knowledge and understanding of Database.
· 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.
CS403 Assignment_1 Solution FALL_2018 ---------------------- Download
Semester: FALL 2018
Assignment No. 1
Total Marks: 20
Due date: 26 November, 2018
 |
| CS403-DBMS ASSIGNMENT 1 SOLUTION FALL 2018 |
CS403-DBMS Assignment 1 #Instructions
Instructions:
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
§ The assignment is submitted after due date.§ The assignment is not in the required format (doc or docx)
§ The submitted assignment does not open or file is corrupt.
Assignment is copied(partial or full) from any source (websites, forums, students, etc)
CS403-DBMS Assignment 1 #Uploading Instructions
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-DBMS Assignment 1 #Objective
Objective
The objective of this assignment is
· To give basic knowledge and understanding of Database.
· To be able to understand Conceptual Database Design.
CS403-DBMS Assignment 1 #Note
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 26/11/2018.
CS403-DBMS Assignment 1 #Question
Question
“Stay Fit” is a gym equipment
providing company. Company buys exercise machines from different suppliers.
Company provides different types of exercise machines of different suppliers to
gyms or home customers. Special discount is offered to regular customers.
Customers place order and after checking the availability of the demanded
machines, order is confirmed. After order confirmation, order is dispatched.
Every order has a voucher (bill). When order is received, customers pay the
bill.
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.
·
Draw the context
level diagram.
·
Identify Entities, their
attributes, relationships among entities in above scenario and draw Entity
Relationship Diagram (ERD) for it.
Note: You are
required to submit Context level diagram and ERD as your solution only.
CS403-DBMS Assignment 1 Solution !Download!
CS403 Assignment_1 Solution FALL_2018 ---------------------- Download