Developing and managing efficient and effective database applications requires understanding the fundamentals of database management systems, techniques for the design of databases, and principles of database administration. The purpose of this course is to introduce the fundamental concepts of database management, including aspects of data models, database languages, database design, relational algebra, and query processing. Relational database systems are the main focus, but other types, including NoSQL databases, are studied. The practical design of databases and development of database applications using modern software tools will be emphasized.
Fundamentals of Relational Database Management Systems, Sumathi and S. Esakkirajan, SpringerVerlang,2010.
Course Schedules
Week
Contents
Learning Methods
1. Week
Databases and Database Users.
Oral presentation, Laboratory.
2. Week
Database System Concepts and Architecture.
Oral presentation, Laboratory.
3. Week
The Relational Data Model and Relational Database Constraints.
Oral presentation, Laboratory.
4. Week
Basic SQL.
Oral presentation, Laboratory.
5. Week
More SQL: Complex Queries, Triggers, Views, and Schema Modification.
Oral presentation, Laboratory.
6. Week
Data Modeling Using the Entity-Relationship (ER) Model.
Oral presentation, Laboratory.
7. Week
Relational Database Design by ER- and EER-to-Relational Mapping.
Oral presentation, Laboratory.
8. Week
Midterm.
Midterm.
9. Week
Implementing Stored Procedures.
Oral presentation, Laboratory.
10. Week
The Enhanced Entity-Relationship (EER) Model.
Oral presentation, Laboratory.
11. Week
Basics of Functional Dependencies and Normalization for Relational Databases.
Oral presentation, Laboratory.
12. Week
Functions and XML (Extensible Markup Language).
Oral presentation, Laboratory
13. Week
Introduction to NoSQL.
Oral presentation, Laboratory.
14. Week
Term Project Presentations.
Term Project Presentations.
15. Week
Final.
Final.
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
20
Homework / Term Projects / Presentations
1
20
Project(s)
1
20
Final Exam
1
40
Program Outcomes
PO-1
Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems.
PO-2
Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose.
PO-3
Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety issues, and social and political issues according to the nature of the design.)
PO-4
Ability to devise, select, and use modern techniques and tools needed for engineering practice; ability to employ information technologies effectively.
PO-5
Ability to design and conduct experiments, gather data, analyse and interpret results for investigating engineering problems.
PO-6
Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
PO-7
Ability to communicate effectively, both orally and in writing; knowledge of a minimum of one foreign language.
PO-8
Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
PO-9
Awareness of professional and ethical responsibility.
PO-10
Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development.
PO-11
Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions.
Learning Outcomes
LO-1
Provide students with the opportunity to learn the basic concepts of database development and management
LO-2
Provide students with hands-on experience in designing, developing, and maintaining database systems.
LO-3
Help students understand the role of database in various types of information systems and its importance in real world applications.
LO-4
Be familiar with commercial relational database systems (Oracle,SQL Server)
LO-5
Discuss the concepts and fundamental principles involved in database systems
LO-6
Develop data models using ER/EER diagramming.
LO-7
Discuss the role of normalization in database design and normalize a set of tables up to 3rd normal form.
LO-8
Use SQL to create, query, and maintain relational tables
LO-9
Be familiar with the basic issues of transaction processing and concurrency control.