Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    Quiz 100% Result
    • CS312 Assignment 3 Solution and Discussion

      zaasmi

      Re: CS312 Assignment 3 Solution and Discussion
      Assignment No. 03

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

      Due Date:
      July 27, 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,
      • Basics of developing Database by designing tables using ERD
      • Using ERD transformation techniques to design relations
      • Normalization of Tables from 1st to 3rd Normal form

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

      Assignment 3
      TASK to perform

      You are required to use solution of your Assignment No 2 (Uploaded by course instructor) i.e. ERD and transform this ERD into relations / tables that are in 3rd normal form.

      Important Note:

      No marks would be awarded if your tables are not in 3rd normal form. You are not required to show all phases to convert tables into normal forms. Only tables in 3rd normal form would be required.

      Best of Luck!

      CS312 - Database Modeling and Design
    • CS312 Assignment 2 Solution and Discussion

      zaasmi

      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!

      CS312 - Database Modeling and Design
    • CS312 Assignment 1 Solution and Discussion

      M

      Re: CS312 Assignment 1 Solution and Discussion
      Assignment No. 01

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

      Due Date:
      June 01, 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,
      • Giving the idea of the most common tool used in designing database systems i.e. Software Requirement Specification
      • To become familiar with Software Requirement Specification document and to define complexities in the system.

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

      After interview with a customer, System analyst write a detailed ruff report of system specification that is provided to you below;
      System Requirements

      Tour de Pakistan (TdP) is a private limited company, offering a variety of tours within Pakistan which are highly in demand along with newly entertaining visiting spots as well and hence most of their customers book their tours well in advance.

      During each tour, the customers / travelers will be visiting many sites. All those sites offer site seeing, however only some of those sites offer various activities in which the visitors / customers can participate. Some of the sites that are visited in a tour may also be included in other tours. For each of the tours, a tour guide is allotted by TdP.

      Each tour must have a distinct name containing sites and activities (if available on those sites) and fixed no of seats. So, few sites in tour may be with activities while other are without activities. Sites with or without activities are not fixed and totally depends on company’s owners tat design the tour as per customer’s demand / visitor’s trends. Only one tour guide is allocated for one tour. Prices for tours are fixed and payments are done by visiting their office or deposited online if tours are reserved online.

      The web page should have necessary controls and easy to understand layout that are necessary to receive the input data and the application should store them appropriately. The web page’s layout is left to developer’s choice, but it must be simple, attractive and understandable. The page should also be user-friendly and is expected to display appropriate error/warning messages. The data type for each of the inputs has not been mentioned purposely. You need to use appropriate data type accordingly.

      Only owners / administration will create / authenticate tour guide’s login. Administration has responsibilities to create tours, sites and activities while owners would also have authority to enter / edit / create tours with limited / fixed seats. Plans are viewed by travelers and then book number of seats against each tour and payments are done by using credit card. Visitor / traveler is not allowed by system to book two different tours which start or end dates are overlapped. Visitor / traveler may apply for cancelation of tour plan and concerned administration and owner only allowed to cancel that tour reservation before one week of start date.

      TASK to perform

      You must identify following from the project specification / requirements that are written by System analyst after interview with customer;

      1 - User Characteristics or type of users [10 Marks]
      2 - Functional Requirements (at least 5) [10 Marks]

      Best of Luck!

      CS312 - Database Modeling and Design
    • CS312 Assignment 2 Solution and Discussion

      zareen

      Assignment No. 02

      Semester: Fall 2019
      CS312: Data Base Modeling and Design Total Marks: 20

      Due Date:
      December 10, 2019

      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, you have to identify and design following;

      Task:

      By using system requirements in assignment 1, you are required to identify Entities in the University Certificates system and use identified entities to draw ER diagram along with assumed attributes and cardinalities between entities.

      Best of Luck!

      CS312 - Database Modeling and Design
    • CS312 Assignment 3 Solution and Discussion

      zareen
      Assignment No. 03

      Semester: Fall 2019
      CS312: Data Base Modeling and Design Total Marks: 20

      Due Date:
      January 30, 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,
      • Basics of developing Database by designing tables using ERD
      • Using ERD transformation techniques to design relations
      • Normalization of Tables from 1st to 3rd Normal form

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

      Assignment 3
      TASK to perform

      You are required to use solution of your Assignment No 2 (Uploaded by course instructor) i.e. ERD and transform this ERD into relations / tables that are also in 3rd normal form.

      Important Note:

      No marks would be awarded if your tables are not in 3rd normal form. You are not required to show all phases to convert tables into normal forms. Only tables in 3rd normal form would be required.

      Best of Luck!

      CS312 - Database Modeling and Design
    • CS312 Assignment 1 Solution and Discussion

      zareen
      Assignment No. 01

      Semester: Fall 2019
      CS312: Data Base Modeling and Design
      Total Marks: 15

      Due Date: 14/11/2019

      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,
      • Giving the idea of the most common tool used in designing database systems i.e. Software Requirement Specification
      • To become familiar with Software Requirement Specification document and to define complexities in the system.

      For any query about the assignment, contact at

      After interview with a customer, System analyst write a report of system specification that is provided to you below;

      Scenario / System Requirements

      The aim of this project is to develop a website named as “University Certificate Management” to provide instant updates about the status of an application in a University. Using this web-based application, students can submit their applications to the relevant department and then track the progress of their applications. Verifier can login to the system and check the certificates given by University are valid or not. The users of this website are Admin, Students, Teachers, Examination Clerical Staff, Finance staff and from outside Verifier.

      The system will store the below information in it.

      • Student basic Details
      • Semester and Course Details
      • Certificate Templates
      • Events/Functions Details
      • Staff Details

      To use the system, user must be register with the system. The system admin have to approve user registration request. Only Clerical Staff and Teachers are allowed to insert the data. Students can only view the details and apply for the required certificate. Verifier can only check certificate authenticity. Only admin has right to see / alter some basic information of users e.g. in case of password lost, admin would help user to recover / reset system password.

      Major properties that system should have:

      Following are the key functional requirements of proposed Project:

      • Sign In and User Registration

      There will be two categories of users:

      • Internal Users (Admin, Students, Teachers, Examination Clerical Staff, Finance staff)
      • External Users (Verifier)

      Clerical Staff will have the privileges to upload students and teachers information on the website.
      Admin will be the user of website having rights of user management. Admin will approve the registration requests from users and recover accounts for registered users.
      There will be Sign In interface for registered users and Sign Up interface for unregistered users to register on the website.

      • Information Uploading / Posting

      • Examination Clerks are responsible for Semester and course related data management and assign courses to Teachers.
      • Teachers are responsible for the grades and the assessment related data of their students.
      • Finance Clerks are responsible of Fee related data management.

      • Information Retrieval:

      • Students can check their pass courses and request for certificates.
      • External Users can only verify the certificates after authentication.

      • Generating Certificates

      • A verification interface must present to check whether request is valid or not.
      • Examination Clerks create certificate on user request after proper verification.

      Tasks to Perform

      You have to identify following from the project specification / requirements that are written by System analyst after interview with customer;

      1 - User Characteristics or type of users [5 Marks]
      2 - Functional Requirements (at least 5) [10 Marks]

      Best of Luck!

      CS312 - Database Modeling and Design

    CS312 Assignment 3 Solution and Discussion

    CS312 - Database Modeling and Design
    assignment 3 cs312 discussion solution spring 2020
    2
    2
    11
    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 3 Solution and Discussion
      Assignment No. 03

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

      Due Date:
      July 27, 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,
      • Basics of developing Database by designing tables using ERD
      • Using ERD transformation techniques to design relations
      • Normalization of Tables from 1st to 3rd Normal form

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

      Assignment 3
      TASK to perform

      You are required to use solution of your Assignment No 2 (Uploaded by course instructor) i.e. ERD and transform this ERD into relations / tables that are in 3rd normal form.

      Important Note:

      • No marks would be awarded if your tables are not in 3rd normal form.
      • You are not required to show all phases to convert tables into normal forms. Only tables in 3rd normal form would be required.

      Best of Luck!

      1 Reply Last reply Reply Quote 0
      • Mehr Ali
        Mehr Ali last edited by

        Idea solution please

        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        50% Off on Your FEE Join US!

        Quiz 100% Result If you want to know how you can join us and get 50% Discout on your FEE ask Cyberian in Chat Room! Quiz 100% Result Quiz 100% Result
        solution1241 discussion1193 fall 2019813 assignment 1425 assignment 2295 spring 2020265 gdb 1246 assignment 382 crw10174 spring 201955
        | |
        Copyright © 2021 Cyberian Inc. Pakistan | Contributors
        Live Chat