We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS312 Database Modeling and Design Assignment No 01 Spring 2020 Solution & Discussion Due Date: 01-06-2020

CS312 Database Modeling and Design Assignment No 01 Spring 2020 Solution & Discussion Due Date: 01-06-2020

CS312 Database Modeling and Design Assignment 1 Solution & Discussion Spring 2020


 

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 CS312@vu.edu.pk

   

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!


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 28

Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

Students having same subject can start discussion here to solve assignment, GDB & Quiz and can clear their concepts until solution is provided. 

 

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Then copy Questions from assignment file and paste in Discussion.

 

http://bit.ly/vucodes (For Assignments, GDBs & Online Quizzes Solution)

http://bit.ly/papersvu (For Past Papers, Solved MCQs, Short Notes & More)

Click Here to Search (Looking For something at vustudents.ning.com?)

Click Here to Join (Our facebook study Group)

RSS

Latest Activity

khaaniii replied to Imtiaz Waqar's discussion COST AND MANAGEMENT ACCOUNTING (MGT402) ASSIGNMENT NO. 01 in the group MGT402 Cost & Management Accounting
33 minutes ago
Profile Iconkhaaniii and Muhammad Abid joined +M.Tariq Malik's group
37 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MKT630 International Marketing GDB No 01 Fall 2020 Solution / Discussion in the group MKT630 International Marketing
42 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion MKT630 International Marketing GDB No 01 Fall 2020 Solution / Discussion
42 minutes ago
+M.Tariq Malik added a discussion to the group MKT630 International Marketing
43 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MGMT622 Management Skills GDB Fall 2020 Solution / Discussion Last Date: 27-11-2020 in the group MGMT622 Management Skills
47 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion MGMT622 Management Skills GDB Fall 2020 Solution / Discussion Last Date: 27-11-2020
47 minutes ago
+M.Tariq Malik added a discussion to the group MGMT622 Management Skills
48 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion HRM627 Human Resource Development GDB Fall 2020 Solution / Discussion Last Date: 27-11-2020 in the group HRM627 Human Resource Development
49 minutes ago
+M.Tariq Malik added a discussion to the group HRM627 Human Resource Development
54 minutes ago
Profile IconRANA ATEEB SALEEM, Shahzeb Zubair, Rana Fiaz Rasool and 17 more joined Virtual University of Pakistan
1 hour ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS205 Information Security Assignment 01 Fall 2020 Solution / Discussion Due Date: 26-11-2020 in the group CS205 Information Security
1 hour ago

Looking For Something? Search Here

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.