|
Database Design Case Study
Exercise 1 :
What are the main applications used in your organisation (i.e. not MS Office,
but applications that the business use to function)
Exercise 2 :
Using a ER Design tool
You can use ERWin which
is on the lab PCs or you can download Oracle Data Modeller
To Run ERWin got to
Log into the Galway
application server using
the icon on
the left hand side of the screen
Log in with your username
and password, with the Domain being CS
Go to Start -> Programs
then
To create a new model
From the main menu select
File > New
Select the radio button
Physical
Target Database : Oracle
version 10x
Make sure
you set the model notation to use the crows feet approach
Select 'Model' from main
menu
Then 'Model Properties'
Then select the
'Notation' tab
Select IE (Information
Engineering
You can now start creating
your ER model
To generate a DDL Script
Select Tools from the main
menu
Select Forward Engineer /
Schema Generation
Select Table on the left of
the window
Select CREATE TABLE, DROP
TABLE, TABLE CHECK, PHYSICAL STORAGE from the right hand side of the window
Un-check every thing else
Click on the Preview Button
The window should contain
all your DDL code
Copy and paste this into
Notepad and save as a SQL file.
Or you can create the
file using the Report button
You can not run this in
your Oracle Schema SQL> @c:\xxx.sql
|
