# SOLVED CS312 Assignment 2 Solution and Discussion

• ``````Assignment No. 02
``````

Semester: Spring 2020
CS312: Data Base Modeling and Design Total Marks: 20

Due Date:
June 17, 2020

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 submitted assignment does not open or file is corrupt.
• Assignment is copied (partial or full) from any source (websites, forums, students, etc.)

Note: You have to upload only .doc or .docx file. Assignment in any other format (extension) will not be accepted and will be awarded with zero marks.

Objectives:
The objectives of this assignment are,
• Know basics of Requirement specification to ER modeling
• Basics of developing Database by designing ERD

For any query about the assignment, contact at [email protected]

Assignment 2

In continuation of assignment 1 of CS312, by using system requirements, we identified following entities in the system under observation;

• Admin / Owner
• Tour Plan
• Sites
• Activity
• Visitor
• Guide

By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side that would result in deduction of marks. So, your Task is to;

TASK: [Marks = 10 + 10 = 20]

Draw ER diagram containing entities, assumed attributes and cardinalities between these entities.

(If you have any assumptions regarding system then also specify these in your solution.)

Best of Luck!

• In continuation of assignment 1 of CS312, by using system requirements, we identified following entities in the system under observation;

Tour Plan
Sites
Activity
Visitor
Guide

By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side that would result in deduction of marks. So, your Task is to;
TASK: [Marks = 10 + 10 = 20]
Draw ER diagram containing entities, assumed attributes and cardinalities between these entities.

• In continuation of assignment 1 of CS312, by using system requirements, we identified following entities in the system under observation;

Tour Plan
Sites
Activity
Visitor
Guide

By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side that would result in deduction of marks. So, your Task is to;
TASK: [Marks = 10 + 10 = 20]
Draw ER diagram containing entities, assumed attributes and cardinalities between these entities.

1

1

3

1

3

3

2

9
| |