CENG 315

Information Management

Relevance of information management in the context of computer engineering; introduction to database systems and the relational model; normal forms and their benefits; building databases, underlying methodology, database languages; issues associated with information retrieval; SQL, its use and power; information systems in the context of networks, intranets, extranets; special systems and applications; particular issues, access, security, and integrity; relevant legal and ethical issues.

Learning Outcomes:

1. To be able  to design a relational database.
2.To be able to create a relational database.
3.To be able to learn relational algebra and SQL.
4.To be able to learn how to apply normalization to databases.
5.To be able to learn database concurrency methods.
6.To be able to learn methods to provide consistency and privacy in databases.
7.To be able to learn project development and presentation capability by teamwork.

Topics
Introduction to Database Management Systems
Architecture of Database Management Systems
Relational Model
Relational Database Design
Relational Algebra
SQL (DML)
SQL (DDL)
Normalization
Consistency and Security
Efficient Query Optimization
Server and Clients
JDBC
Concurrency
Term Projects