|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Entity Relationship Diagram
The company has an agency in the capital
cities of various countries around the world. Each travel agency only organizes local tour, no inter-countries are available. Customers book on these tours (a given customer may book on many tours) and may pay for the tour in a series of installments. For each payment, a receipt is issued containing a receipt number (5 digit max - 99999), date of payment (Date), customer number, amount of payment and the tour number. For each tour the company maintains a worldwide unique tour number (99999), the tour name (20 characters - C20), tour description (C50), maximum number of participants (maximum of 99), the date of departure (date), and return (date), the adult tour cost (99999.99), the child tour cost (99999.99) and details for each overnight stop on the tour which include the date of stop (date), hotel name (C20), hotel fax number (C15), and city (C20) for each overnight stop in the tour. Each customer is assigned a worldwide unique customer number (99999). The company also maintains data on family name (C20), given name (C20), street address (C20), town/city (C20), postcode/zip (C4), and telephone number (C10 - not all customers have a telephone number), of each customer. When a customer books a tour, the company also records the date of the booking, the number of adults and number of children booked on the tour, the total amount owed by the customer on this tour and their current outstanding balance on this tour. If the customer pays for a tour by installments, this outstanding balance is modified each time a payment is made. For each agency, the agency code (C2), agency name (C20), agency address (C40), telephone number (C10), and manager's name (C20) are recorded. should Use Crow Foot model, and develop a comprehensive ERD based on the scenario above. Complement the ERD with the necessary cardinalities and important attributes & important keys (Primary & Foreign Key). plz help |
|
#2
|
||||
|
||||
|
What have you come up with so far?
__________________
Daryl's Homepage | My Blogroll | My Profile | Firefox supporter! DevArticles Forum Moderator "The net is a waste of time, and that's exactly what's right about it." -- William Gibson |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Entity Relationship Diagram |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|