CS312 Assignment 2 Solution and Discussion


  • Cyberian's Gold

    Re: 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
    TASK to perform

    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!


  • Cyberian's Gold

    @zaasmi said in CS312 Assignment 2 Solution and Discussion:

    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.

    3cbd2d00-8d98-4fc8-9190-93dd10b22944-image.png


  • Cyberian's Gold

    @zaasmi said in CS312 Assignment 2 Solution and Discussion:

    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.

    3cbd2d00-8d98-4fc8-9190-93dd10b22944-image.png



Quiz 100% Result Quiz 100% Result
| |