Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved

    SOLVED CS312 Assignment 2 Solution and Discussion

    CS312 - Database Modeling and Design
    cs312 assignment 2 solution discussion spring 2020
    1
    2
    224
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • zaasmi
      zaasmi Cyberian's Gold last edited by

      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!

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      NOTE: Don't copy or replicating idea solutions.
      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      zaasmi 1 Reply Last reply Reply Quote 0
      • zaasmi
        zaasmi Cyberian's Gold @zaasmi last edited by

        @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

        Discussion is right way to get Solution of the every assignment, Quiz and GDB.
        We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
        Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
        NOTE: Don't copy or replicating idea solutions.
        Quiz Copy Solution
        Mid and Final Past Papers
        Live Chat

        1 Reply Last reply Reply Quote 0
        • zaasmi
          zaasmi Cyberian's Gold @zaasmi last edited by

          @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

          Discussion is right way to get Solution of the every assignment, Quiz and GDB.
          We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
          Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
          NOTE: Don't copy or replicating idea solutions.
          Quiz Copy Solution
          Mid and Final Past Papers
          Live Chat

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          banner
          Insaf Sehat Card Live Cricket Streaming

          100% Off on Your FEE Join US! Ask Me How?

          Quiz 100% Result If you want to know how you can join us and get 100% Discount on your FEE ask Cyberian in Chat Room!
          Quiz 100% Result Quiz 100% Result
          solution1255 discussion1206 fall 2019813 assignment 1433 assignment 2297 spring 2020265 gdb 1248 assignment 382 crw10174 spring 201955
          | |
          Copyright © 2021 Cyberian Inc. Pakistan | Contributors
          Live Chat