1. Objectives
1.1. At the the end of the session the student will be able to
1.1.1. Identify the delivery pattern of the course
1.1.2. Identify the assessment requirements of the course
1.1.3. Adopt the required learning behaviours for the module
1.1.4. Define the advantages of using Database Systems
1.1.5. Describe the major components of the DBMS environment
2. Course overview
2.1. Structure
2.1.1. 3 hour lecture + 30 min tutorial + 1 hr online learning
2.2. Assessment
2.2.1. 2 Written assessments due week 10 and week 15
2.2.2. No late submissions
2.2.3. 1 submission
2.2.4. Plagarism
2.3. Learning behaviour
2.3.1. All lessons must be attended on time
2.3.2. Phones turned off
2.3.2.1. 1 warning then in the box
2.3.3. Respect
2.3.4. No eating or drinking in the labs
2.3.5. Ask questions
2.3.6. Take notes
2.3.7. talk to the others
2.3.7.1. social groups
2.3.7.1.1. slack
2.3.7.1.2. whatsapp
3. Basics
3.1. All software accesses and\or stores data
3.2. Database Examples
4. File based systems
4.1. Each program defines and manages is own data
4.2. Limitations
4.2.1. Separation and isolation of data
4.2.2. Duplication of data
4.2.3. Data dependence
4.2.4. incompatible file formats
5. Database approach
5.1. Database
5.1.1. Shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization.
5.1.2. System catalog (metadata) provides description of data to enable program–data independence.
5.1.3. Logically related data comprises entities, attributes, and relationships of an organization’s information.
5.2. DBMS
5.2.1. A software system that enables users to define, create, maintain, and control access to the database.
5.2.2. (Database) application program: a computer program that interacts with database by issuing an appropriate request (SQL statement) to the DBMS.
5.3. Data definition language (DDL).
5.4. Data manipulation language (DML).
5.5. Controlled Access
5.5.1. a security system
5.5.2. an integrity system
5.5.3. a concurrency control system
5.5.4. a recovery control system
5.5.5. a user-accessible catalog.
6. Views
7. Components of DBMS Environment
7.1. hardware
7.2. Software
7.3. Data
7.4. Procedures
7.5. People
7.5.1. Data Administrator (DA)
7.5.2. Database Administrator (DBA)
7.5.3. Database Designers (Logical and Physical)
7.5.4. Application Programmers
7.5.5. End Users (naive and sophisticated)