Introduction to Database

Course Description:

The focus of the course is covering fundamental database concepts in the relational database management system (RDBMS) on the subjects: relational data modeling and design, abstract relational languages, and structured query language (SQL). Students design and implement a database application for their project. Few sessions are allocated to provide a general overview of several topics such as integrating structured data and text, query optimization, recovery, concurrency control, data warehousing, and data mining.

Course Goals - Students should be able to:

Design and model a design scenario using relational data modeling, which includes:

Analyze the design anomalies.
Construct Entity Relationship Diagram.
Analyze and Construct Functional Dependencies for the business rules.
Analyze Functional Dependencies to identify Primary keys.
Analyze and Perform Normalization and Normal Forms.
Define referential integrities.
Create relational database design schemas in 3-NF/BCNF for a design scenario of the size of ca. 8-10 tables.

Solve abstract relational language, such as relational algebra problems.
Solve database transactions by using Structured Query Language (SQL), used by RDBMSs.
Explain the general concept of the additional topics such as: Query Optimizations, Concurrency Control, Recovery, structured data and text, and data warehousing.
Implement a relational database application. This includes both the design and the implementation of an application that uses a relational database management system for the storage of the data and provides a user interface for the insertion, deletion, update and query of the data in this database by a user.

Prerequisite:

COSC-160

Course Announcements/ Discussion Board/ Class Notes:

Located on the Canvas!

Textbook:

You should have one of these textbooks-- your choice to choose! Both are very good books:

Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts, McGraw-Hill, ISBN 0-07-295886-3
R. Ramakrishnan and J. Gehrke, Database Management Systems, McGraw-Hill, ISBN 0-07-246563-8 0072283637

Grading (Tentative-will be finalized by the 1st day of the class!)

Project		A final demo of the project will be given to me.
Assignments		SQL HW Design HW Information will be given in the class.
Exams		Two or Three Exams. Detail will be announced in the class! Exam Dates: TBD - will be announced in the class and on Canvas as the semester progresses. NO makeup exams will be given if you do not show up in the exams, unless it has been an emergency health related matter, in which case you need to bring me a doctor note and contact me ASAP! !! Date: TBA

Project:

Students are given the system description and requirements of an enterprise and asked to design the system, document the design, create the database, implement the business requirements, user queries and database transactions, and a user interface for the application. The interface is used for the user to insert data, delete data, update data and finally query data. Deliverables include a is database design document, test document, and the software. Students are required to give a demonstration of their working application by the project due date. The detailed description of the group project will be provided in a separate handout. Students are required to use a commercial or open source RDBMS (needs to be discussed with me) for the back-end of their database application. Any programming language may be used.

Course Content (Tentative):

TOPICS	SLIDES
Introduction
Introduction to Relational Model
Relational Algebra
Structured Query Language (SQL)
Relational Database Design (ERD, Functional Dependency, Refrential Integrity, Normalization,...)
Integration of Structured Data and Text
Overview of: Query Optimization, Recovery, Concurrency Control
No SQL
Overview of Data Warehousing & Data Mining

Late Assignment Policy:

Assignments MUST be submitted on or before their due date. If you are not able to finish your assignment by the due date and time, simply submit whatever of the assignment you have done to get some points rather than a zero. The students are encouraged to re-work on the incomplete assignments. This does not change the grade for that assignment, however will be considered if the final grade is in border-line.

Academic Integrity:

Visit the Honor System Website at http://gervaseprograms.georgetown.edu/honor/