CS403 - Database Management Systems Assignment No. 1 Solution and Discussion Fall 2014 Due Date: 19th Nov.2014

Assignment No. 1

Semester Fall 2014
Database Management Systems – CS403

Total Marks: 15

Due Date: 19th Nov 2014

Objective:

The assignment has been designed to develop the understanding related to the followings,

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit (zero marks) due to followings,

1. The assignment is submitted after due date.
2. The submitted assignment does not open or file is corrupt.
3. The assignment not submitted in MS Word file format (You can copy diagram from Visio to Word).
4. The assignment is copied (from other student or copied from handouts or internet).
5. Student ID is not mentioned in the assignment file or name of file is other than student ID.

For any query about the assignment, contact only at CS403@vu.edu.pk

Do not post queries related to assignment on MDB.

GOOD LUCK

Question 1 [15 Marks]

Read the following requirements carefully and draw the Data Flow Diagrams Level 0 and Level 1 using Microsoft Visio.

Tourism Website

Suppose we are going to develop a website “PAK Tourism” for tourism promotion. Required functionality will be:

A general visitor may view “Travel Guide” information for different areas of Pakistan. This information will include “Weather “, “Currency Info”, "Do's and Don'ts" ,”Customs”, etc .
Moreover he may view “Tour Packages” offered by PAK Tourism by selecting a Destination (Historical places, Parks, Lakes, City tour ,Northern Areas, etc) and after selecting sub category visitor can read tour complete info.(including No. of days , “Amount”, “Accommodation info”, “ Attractions” etc)
A visitor can send Query to “PAK Tourism” by filling a small form including Name, email, phone and Query. Visitor will get response same day through email.
A visitor may get Registration after filling “Sign Up” form.

A Registered user will have additional functionality:

After getting login, user may book a Tour by filling form (which will include available options and payment modes)

Solution