Re: CS312 Assignment 1 Solution and Discussion
Assignment No. 01
Semester: Spring 2020
CS312: Data Base Modeling and Design Total Marks: 20
June 01, 2020
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.
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;
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!