Database management system course syllabus

What is the course content of Database Management System?
In this background the course examines data structures, file organizations, concepts and principles of DBMS's, data analysis, database design, data modeling, database management, data & query optimization, and database implementation..
What is the syllabus of database management?
1Introduction to Database Concepts Database Environment2Relational Model Entity Relationship Model Quiz #1Quiz #13Basic SQLTables DB Creation Quiz #2Quiz #24Data Modeling Constraints & Data Manipulation Quiz #3 Project OverviewQuiz #3.

This course will address the theory, application, and management of relational database technology. The benefits supported by database systems is particularly

Format

The class meets three times a week for lectures. We will follow parts of thetextbook (see below). While the lectures are designed to be clear andself-contained

Assignments

There will be several homework assignments, involving light programming.See the homework page

Exams

The course will have both a midterm and a final exam. See the exams pagefor more information

Textbooks

The required textbook for this course is: 1. Database Systems: the Complete Handbook, by Hector Garcia-Molina, JenniferWidom

Late Policy

For homework assignments, you are allowed a total of four late days(each giving an additional 24 hours) with at most two late days perassignment

Programming

Some programming will be necessary in this course. One can only start toappreciate database systems by actually trying to use one

Course Tools

The course website and mailing list will be used extensively to provide youwith course information, such as the schedule mentioned above

Collaboration Policy

You are encouraged to discuss the content of this course with anyone youlike; however, unless otherwise stated

Academic Misconduct

Any attempt to misrepresent the work you submit will be dealt with via theappropriate University mechanisms

What is a database management course?

This is an upper-level course on the internals of database management systems

This course has a heavy emphasis on programming projects

There are also readings assigned for each class, homeworks, and two exams

Upon successful completion of this course, the student should be able to: Use relational algebra to express database queries

What is a database system?

The database system hides many of the lowest level storage details from the database programmers

Database Administrators may be aware of certain details of physical organization of data

This is the next higher level of abstraction which describe what data are stored in database, relation between data, types of data etc

What is DBMS system?

Sales: DBMS system allows the data to be stored in electronic format by making use of relational databases which allows the data to be stored in highly organised manner

This database allows the information such as information about the customers, products, sales, purchases etc to be stored in database

Categories