Create a subject area diagram for a small section in the hotel system.
For this subject area diagram, think about the process of a customer checking in to a room. The components (entities) that are involved in a customer checking in are as follows:
▪Guest: The customer
▪Reservation: The customer reserves a room
▪Shift: The time of day that correlates with a sales clerk
▪Room: The room the customer reserves
▪Vehicle: If the customer needs a parking space
Include these entities in your subject area diagram.
To create a subject area diagram of a customer checking in to a hotel
1 Open the Tutorial encyclopedia. (Select File > Open Encyclopedia > Existing. Select your Connection name, then highlight the Tutorial encyclopedia, click OK.)
2 Select the Data Modeling tab in the Explorer.
3 Click File > New Diagram.
4 Double-click Entity Relation.
5 In the New Diagram dialog box, enter the name Hotel Check-In. Click OK. The Diagram-Entity Relation dialog opens. In this dialog specify the model that you are representing the diagram's status (whether it is going to be a model diagram or a subject area of a model), and the DBMS.
6 For the Model property, click Choices. The Select and Drag dialog opens, presenting a list of models already created in this project encyclopedia. The dialog should only display the model Hotel Reservation System. Select and drag Hotel Reservation System into the Model property box and close the Select and Drag dialog (by clicking on X in its upper right corner). (If no model existed at this point, you could type a new model name in the box and click Define to create it.)
7 For the Diagram Status property, toggle Subject Area.
8 Select ANSI for the DBMS property. Logical data models are usually not set to a specific DBMS.
Note The selections presented in this list are dependent on the Database Properties you selected in the Customize Method Support dialog. To add different DBMS's to this list, select Tools > Customize Method Support. Select one or more DBMS's in the Target Databases list, and reopen the encyclopedia.
9 Click OK to close the dialog and create the Entity Relation diagram.
