 |
Assignment No. 01
SEMESTER Fall 2018
CS403- Database Management System
|
Total Marks: 20
Due Date: 26/11/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:
·
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.
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.
Lectures Covered: This assignment covers
Lecture # 01 - 10
Deadline
Your assignment must be uploaded/submitted at or before 26/11/2018.
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.
=====================================Ended=======================================
For any query about the assignment, contact
at CS403@vu.edu.pk
GOOD LUCK
|
||
|
|
||
|
|
Assignment No. 01
SEMESTER Fall 2018
CS403- Database Management System
|
Total Marks: 20
Due Date: 26/11/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:
·
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.
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.
Lectures Covered: This assignment covers
Lecture # 01 - 10
Deadline
Your assignment must be uploaded/submitted at or before 26/11/2018.
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.
=====================================Ended=======================================
For any query about the assignment, contact
at CS403@vu.edu.pk
GOOD LUCK
|
||
|
|
||
No comments:
Post a Comment