In this course, we will explore the fundamental concepts behind the design
of databases, database models, and the implementation of relational databases. Students
will do at least one project on the ORACLE relational Database Management
System.
The topics we hope to cover are: |
| |
|
Semantic Models: Entity-Relationship (ER) Diagrams |
| |
|
Database Models: Relational Model |
| |
|
Converting from ER to Relational schema |
| |
|
Relational Database Design Theory |
| |
|
Other models: object-oriented, semi-structured |
| |
|
Database Languages: SQL |
| |
|
Developing database programs using (Oracle’s) PL/SQL |
| |
|
Physical Organization |
| |
|
(time permitting) query processing |
| |
|
(time permitting) DBMS internals |
| |
|
(time permitting) Object Orineted & Semi Structured database models |
| |
|
(time permitting) Recent Developments: sensor networks, mobile databases. |
| |
| At the end of this course, a student should: |
| |
|
be able to build conceptual models using Entity-Relationship (ER) diagrams; |
| |
|
understand the theory and use of the relational model; |
| |
|
be able to convert from an ER schema to a relational schema; |
| |
|
appreciate the impact of physical data organization; |
| |
|
grasp the introductory concepts behind database concurrency control, recovery,
integrity, security, and distributed databases; |
| |
|
be able to design and implement a database on the Oracle DBMS using SQL
and PL/SQL starting with the description of a small real-world problem. |
