Running table createscripts you will get the isqlplus login screen

July 23, 2023	1

The material in this communication may be subject to copyright under the Act. Any further copying or communication of this material by you may be the subject of copyright protection under the Act. Do not remove this notice.

	2

Students should not copy slides, allow third parties access to the slides or distribute the slides.

Copyright of these slides vests in the university and, where applicable, Cengage Education

	3

• As the semester progresses, the amount of new material introduced each week declines, HOWEVER…

• Tutorial / practical work becomes progressively more intense

	4

• Click on the link

• Have a practice run after you studied the lecture and tutorials

	5

	6

READINGS – WEEK 2

	7

WORKING WITH ORACLE

• Two interfaces – Oracle SQL Client Interface and Web (HTML) interface

• Primary server:

• Reserve server:

Note: Details about your username and password are contained in Tutorial 1

iSQLPLUS 3 (LOGIN SCREEN – RESERVE SERVER)

iSQLPLUS 6

In the workspace tab, you can:

• You can CHANGE PASSWORD from the <Preferences> section.

ISQLPLUS 8

Data Analysis and Modelling

• We use the key elements of the Finkelstein approach for data analysis and modelling

• Modelling - goal is to try and make a model of the requirement to better understand the requirement.

• Models are:

Logical Model

•basis of existing system
•Focuses on WHAT, not HOW•interpret in plain English