Database diagrams are used to find out the relationships that occur between tables in a database. Creating a database diagram is done through Enterprise Manager. After you run Enterprise Manager, do the following steps:
Select the database to be diagrammed. For example, a banking database. On the banking database object, right-click then select the New >> Database Diagram menu.
Next, the Create Database Diagram Wizard menu appears. Click Next.
Then select the table to be related in the Available Tables section. For example, you relate the tables in Chapter 5, after you have finished selecting all the tables, click Add to enter the tables into the Tables to add to diagram section. Then click Next.
Then in the last step click Finish. Next you can see the results of the relationship that has been created, and save the diagram with the name relation_bank.
Task
- For the assignment, create a database and tables as directed by your lecturer. Do as in Chapters 3 -- 6.
- For SQL commands save by name
<nim><klas>.sql, contoh 12080007B.sql. - For diagram database save with
nama <nim>dbg. Contoh 12080007dbg.