SWE4004 S1 Intro

Get Started. It's Free
or sign up with your email address
Rocket clouds
SWE4004 S1 Intro by Mind Map: SWE4004 S1 Intro

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)

8. Advantages of DBMSs

8.1. Control of data redundancy

8.2. Data consistency

8.3. More information from the same amount of data

8.4. Sharing of data

8.5. Improved data integrity

8.6. Improved security

8.7. Enforcement of standards

8.8. Economy of scale

8.9. Balance conflicting requirements

8.10. Improved data accessibility and responsiveness

8.11. Increased productivity

8.12. Improved maintenance through data independence

8.13. Increased concurrency

8.14. Improved backup and recovery services

9. Disadvantages of DBMSs

9.1. Complexity

9.2. Size

9.3. Cost of DBMS

9.4. Additional hardware costs

9.5. Cost of conversion

9.6. Performance

9.7. Higher impact of a failure

10. Questions ?