1 / 11

Chapter One (Introduction)

Chapter One (Introduction). Objectives Introduction to Database Management Systems (DBMS) Relational Databases Model Restrictions of RD Database Life Cycle. Definitions. Introduction to Databases. Database Management Systems(DBMS) Relational Database Management System.

falala
Download Presentation

Chapter One (Introduction)

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. Chapter One (Introduction) Objectives Introduction to Database Management Systems (DBMS) Relational Databases Model Restrictions of RD Database Life Cycle

  2. Definitions • Introduction to Databases. • Database Management Systems(DBMS) • Relational Database Management System

  3. Relational DBMS • RDBM: Data are represented as a set of tables (relation is a mathematical term for a table) • Originated by E.F. Codd (1970) • Based on sets theory

  4. Structure of RDBM: • A set of relations (Tables) • Each relation has a unique name • Each relation has a set of attributes (Columns) • Each relation has a set of tuples (Rows)

  5. Restriction on RDBM: • No two tuples are the same • No two attributes are the same • The order of tuples are immaterial • The order of attributes are immaterial • There is an attribute or a collection of attributes which identifies tuples uniquely called Primary Key • Value of attribute must be atomic

  6. Restriction on RDB: (Continued) Example: Student ( Name, Id, Gpa );

  7. Domains • A set of legal values for an attribute (types)

  8. Database Life Cycle • Analysis: • Study and analyze business requirements • Interview managers and users for the information requirements • Develop a system specification

  9. Database Lifecycle • Design (Data Models) • Entity relational model (ER) • Unify modeling language (UML) • Check the design • Build the Databases/Document/Test • Create tables and views, and programs • Produce manuals

  10. Database Lifecycle • Product delivery • Load the software • Monitor the performance

  11. Practice (Analysis): • Develop a System Specification for a video store:

More Related