HOMEWORK1

HOMEWORK1 - CSCI 585 Database Systems Fall 2010 Homework 1...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CSCI 585 – Database Systems Fall 2010 Homework 1 Lu Li 9/21/2010
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
E-R Data Model Design user itinerary reservation passengers room_types fight_res flights hotels hotel_res cities order contain _res board order_ flight order_ hotel user_id password name firstname middlename lastname phone_numbers iti_num res_num mode_of_ payment ISA res_cost name dob dep_date capacity flight_num airline_cod e to from locate _in own_ro oms name longitude latitude state hotel_name price room_type available_ number include _types number address disjoint check- in_date check- out_date payer_nam e iti_cost hotel_num
Background image of page 2
Assumption/Supplement 1. The system provide and restore a unique user-id for each registered user. 2. There are not two, or more than two hotels having the same name in each city. In addition., considering that hotels may have branches who have the same name in different cities, we use a hotel-number to uniquely identify each single hotel. 3.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/23/2010 for the course CSCI 585 taught by Professor Shamsian during the Fall '08 term at USC.

Page1 / 4

HOMEWORK1 - CSCI 585 Database Systems Fall 2010 Homework 1...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online