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 |