Data Model User Guide

Data Model Diagram User Guide 1 Create a Data Model Diagram 1.1 After Opening the Rational Rose Suite open the file that contains all of your previous work. It should contain Use Case Diagram, Sequential Sequence Diagrams and Collaboration Diagrams.

1.2 Right click on Component View > Data Modeler > New > Database.

1.3 Rename it “DB_Library.”

1.4 Double-click DB_Library. Select the Target: drop down menu and click the database you will be using. Click OK.

1.5 Right click on DB_Library > Data Modeler > New > Tablespace.

1.6 Rename the Tablespace “TSP_Library.”

1.7 Right click Logical View > Data Modeler > New > Schema.

1.8 Rename the schema S_Library.

1.9 Right click S_Library > Data Modeler > New > Table.

1.10 Rename the new table “T_Book.”

1.11 Double-click T_Book and click the Column tab.

1.12 Click the New column button.

1.13 Double click “COL_0” and delete COL_0 in the name field. Now type “title.”

1.14 Click the Type tab. Select the Datatype drop down menu and select VARCHAR.

1.15 In the Length text field replace 1 with 25. Click OK.

1.16 Add the following rows and click OK when finished: Author: VARCHAR(25) ISBN: INTEGER Book_ID: INTEGER set as Primary Key(PK) Genre: VARCHAR(15) Status: VARCHAR(1) Alert: VARCHAR(1) Due date: DATE Library ID: INTEGER

1.17 Create a new table and rename it “T_Account.” Add the following rows to T_Account and click OK when finished: Username: VARCHAR(10) First_Name: VARCHAR(10) Last_Name: VARCHAR(15) Email: VARCHAR(25) Library_ID: INTEGER Password: VARCHAR(20) Position: VARCHAR(1)

1.18 Right click S_Library > Data Modeler > New > Data Model Diagram.

1.19 Rename the new diagram “Library Data Model.”

1.20 Double click the Library Data Model.

1.21 Drag T_Account to the diagram.

1.22 Drag T_Account to the diagram.

1.23 Click on the Non-identifying Relationship button on the center toolbar.

1.24 Drag from T_Account to T_Book.

1.25 Double click the line connecting the two tables.

1.26 Select the Cardinality drop down box and select 0..1 under the Parent form.

1.27 Select the Cardinality drop down box and select 0..n under the Child form.

1.28 Click OK.

1.29 The diagram is now finished. Click File > Save and then File > Exit to close the program. Here is the finished diagram.

T_Book T_Account username : VARCHAR(10) first_name : VARCHAR(10) last_name : VARCHAR(15) email : VARCHAR(25) library_ID : INTEGER Password : VARCHAR(20) Position : VARCHAR(1) <> PK_T_Account1() <> TC_T_Account1() <> TC_T_Account5()

title : VARCHAR(25) author : VARCHAR(25) ISBN : INTEGER book_ID : INTEGER genre : VARCHAR(15) <>status : VARCHAR(1) alert : VARCHAR(1) due_date : DATE 0..* library_ID : INTEGER 0..1 T_Account_library_ID : INTEGER COL_16 : INTEGER username : VARCHAR(10) T_Account_username : VARCHAR(10) <> PK_T_Book0() <> TC_T_Book0() <> FK_T_Book0() <> FK_T_Book1()