《Creatingarelationaldatabase(DDL)FormulatingSQL》.ppt

22 1 1 3 1 5 5 1 1 Introduction * * Relational Database Systems: Creating a relational database (DDL) Formulating SQL queries (DML) Embedded SQL Relational algebra Relational model, relational integrity, etc. Data Modeling: Entity-relationship model Converting an E-R schema into a relational schema Web-Based Database Applications PHP and MySQL Drupal Content Management System (CMS) Course Introduction After this lecture, you should be able to: Understand the differences between Information and Data. Understand the differences between Database and Database Management System (DBMS). Why do we need them? Understand Data Modeling in general, Relational Model in particular. Complete the Assignment 1. Overview of data management From data.gov“Data are values or sets of values representing a specific concept or concepts. Data become information when analyzed and possibly combined with other data in order to extract meaning, and to provide context. The meaning of data can vary according to its context” (Source: Federal Enterprise Architecture Data Reference Model). Data vs. Information Modeling an enterprise, which is an application-world with Entities (e.g., students, courses) Relationships (e.g., Garfield is taking CS275) Creating a database with a database management system (DBMS). Manipulating and Maintaining a database Information Management Data Encoding Information Electronic Charges, Magnetic polarization, etc. Entities, Relationships, etc. Numbers, Strings, Records, Pointers, etc. Bits, Bytes, Pages, etc. Data Modeling A database is an integrated collection of data. A database management system (DBMS) is a software package designed to create and manage a database. The data stored in a database are organized according to the data model supported by the DBMS. A relational database, for example, stores the data in a collection of tables. Database vs. DBMS DBMS Functions Data definition Data manipulation Security and data integrity Recovery and concurrency control