CS403 Assignment 1 Solution fall 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.


<<<DOWNLOAD SOLUTION FILE>>>

Post a Comment

Don't Forget To Join My FB Group VU Vicky
THANK YOU :)

Previous Post Next Post