1 / 7

Database Management System

Database Management System. CEN 351 . Course Description. A database management system (DBMS) is a computer application program designed for the efficient and effective storage, access and update of large volumes of information. This course will look at such systems from two perspectives:

sian
Download Presentation

Database Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DatabaseManagementSystem CEN 351

  2. CourseDescription • A database management system (DBMS) is a computer application program • designed for the efficient and effective storage, access and update of large volumes of information. This course will look at such systems from two perspectives: • • A user-centered perspective focusing on how a DBMS is used to support a data intensive application. This perspective includes a look at the common data models, query languages and design techniques. • • A system implementation perspective focusing on the policies, algorithms and data structures used to design and implement a DBMS.

  3. CourseObjectives • Develop an appreciation of the role of data and databases in information systems. • Understand the database development activities during the System Development Cycle (SDLC) • Be familiar with the data modelling concepts (E-R and Class diagrams) used in database design. • Be able to create databases and pose complex SQL queries of relational databases. • Develop appreciation of several DBMS’s (MS SQL Server) • Be familiar with a broad range of data management issues including data integrity and security.

  4. CourseOutcomes • An understanding of the basic concepts and theoretical knowledge of relational database systems. • A comprehensive skill of data modelling using the entity-relationship modelling technique as well as converting data models into correctly normalized relational database designs. • Having ability of retrieving useful data from an database by using complicated queries in the standard SQL database query language. • Competence in the issues involved in physical database design as well as database security and performance. • An understanding and administering of most common DBMSs

  5. CourseContent • Course Introduction • Database System Concepts and Architecture • Data Modeling Using the Entity Relationship(ER) Model • ER Diagrams, Design Issues • Enhanced Entitiy-Relationship Model • Relational Data Model • Relational Database Concepts • Relational Database Design by ER ande EER to Relational Mapping • Midterm • SQL: Definition and Data Types • Queries in SQL • Advanced Queries in SQL • Data Manipulation in SQL • Distributed Databases and Client Server Architecture

  6. CourseAssesment • MethodQuantityPercentage(%)Quiz215 • Homework410 • Project 1 20 • Midterm Exam(s) 1 15 • Final Exam 1 40 • Total 100

  7. TeachingMethodsandTextBook TeachingMethods • Lectures, • Practical Sessions, • Presentation, • Project, • Assignments Textbook Fundamental of DBMS, 5thEdition,Elmastri/Navathe

More Related