Navigation

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

    CS312 Assignment 1 Solution and Discussion

    CS312 - Database Modeling and Design
    cs312 assignment 1 solution discussion spring 2020
    2
    3
    303
    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.
    • M
      moaaz Cyberian's Gold last edited by

      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!

      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.

      How to Get Earning from Cyberian

      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      For instructions on how to use this Cyberian discussion board

      zaasmi 2 Replies Last reply Reply Quote 0
      • zaasmi
        zaasmi Cyberian's Gold @moaaz last edited by

        @moaaz said in CS312 Assignment 1 Solution and Discussion:

        2 - Functional Requirements (at least 5) [10 Marks]

        Solution:
        Task 2: Functional Requirements

        1. Admin / Owner login
          The admin or owner will login himself by using associated id and password. While owner would act like super Admin.

        2. Tour guide’s registration
          Only admin will be authorized to register the guide of the tour in the system. He will have to authenticate the detail of the tour guide in the system.

        3. Traveler/customer registration and login
          Traveler must register himself before booking any tour. After registration traveler would be able to login to the system and can book the desired tour plan and seats.

        4. Tour guide’s login
          After registration of guide, the guide will be login to the system with provided login details and wait for a tour to be assigned y Admin / owner.

        5. Create and store sites with or without activities
          Only admin will also create and store sites that would have activities not have activities.

        6. Create and store tours and allot a tour guide to a tour
          Admin will create and store the tour details and also allocate a guide for each tour.

        7. Each activity must have a name, duration and number of participants in that activity.

        8. Manage each tour seats reservations
          Admin has the responsibility to make sure that seats for each tour are properly filled. More than available seats for each tour can’t be booked.

        9. Travelers can view the plans for each tour
          Travelers or customer will be able to view the plans for each tour. They will be able to view the complete detail of each tour.

        10. Payments methods
          Payments for tour will be done online using Credit / Debit card.

        11. Visitor / traveler is not allowed by system to book two different tours which start, or end dates are overlapped.

        12. Visitor / traveler may apply for cancelation of tour plan to request system admin
          Traveler would have the opportunity to cancel the booking request for the tour. For this purpose, visitors are required to request admin for the cancelation if the cancelation requirements meet i.e. cancel tour at least one week before its start date. Otherwise he will not be able to cancel the request and claim amount would not be refunded.

        13. Admin would only allow to cancel that tour reservation that must be applied before one week of tour’s start date.

        14. Admin / Owner
          Admin is not authorized to supersede Owner’s decision / edit or delete or even update owner’s tour. While Owner can edit / change / delete admin’s entered information.

        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 @moaaz last edited by

          @moaaz said in CS312 Assignment 1 Solution and Discussion:

          1 - User Characteristics or type of users [10 Marks]

          Solution:
          Task 1: Type of Users

          1. Owner
          2. Admin
          3. Tour Guide
          4. Traveler

          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
          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