DBMS IS212 Chapter 1 Quiz

Course Information

• Course Title: Database Management Systems (DBMS)
• Course Code: IS212
• Department: Information Systems Department
• Faculty: Faculty of Computers and Information
• University: Minia University

Assessment Weightage

• Mid Term Examination: 10%
• Final Term Examination: 60%
• Oral Examination: 10%
• Practical Examination: 10%
• Semester Work: 10%
• Total: 100%

Course Outline

• Introduction to Database
• Relational Data Model and Relational Database Constraints
• Data Modeling Using the Entity Relationship (ER) Model
• Basic SQL
• Database Design Theory and Normalization

Chapter 1: Introduction to Database

Examples of Database Applications

• Purchases from the supermarket
• Purchases using a credit card
• Booking a holiday at travel agents
• Using the local library
• Taking out insurance
• Renting a video
• Using the internet
• Studying at university

Definitions of Database

• Database: An organized collection of logically related data
• Database is a shared collection of logically related data
• Database: A self-describing collection of integrated records
• Database models a particular real-world system in the computer in the form of data

Definitions

• Data: Facts concerning objects and events
• Structured data: numbers, text, dates
• Unstructured data: images, video, documents
• Information: data processed to increase knowledge
• Metadata: data describing properties and context of user data

What is a Database?

• Shared collection of logically related data
• System catalog (metadata) enables program-data independence
• Logically related data comprises entities, attributes, and relationships

Figure 1-1a Data in Context

• This shows example data in a class roster
• Includes course, student ID, major, GPA, etc.
• Context helps understand data

Table 1-1 Example Metadata for Class Roster

• Shows data types, field sizes and description, source

The concept of a shared organizational database

• Diagram illustrating connections between different organizational departments to database
• Highlights how different departments use the database

File Processing System

• A collection of application programs serving end-users
• Each program defines and manages own data
• Diagram showcasing separate files for library, examination and registration

Tables (Library, Examination, Registration)

• Each table depicts data structures for each system

Files Based Processing

• Diagram of file-processing system with sections for data entry, file handling routines, and file definition

Disadvantages of File Processing

• Program-Data Dependence: File structure is defined in the program code
• Duplication of Data (Data Redundancy): Different systems have separate copies of same data
• Limited Data Sharing: Programs can't easily access others' files
• Lengthy Development Times: Programmers design own file formats
• Excessive Program Maintenance: 80% of IS budget
• Vulnerable to Inconsistency: Change in one table needs changes in corresponding tables

SOLUTION: The DATABASE Approach

• Central repository of shared data
• Data managed by a controlling agent
• Stored in a standardized, convenient form
• Requires a Database and Database Management System (DBMS)

Advantages of Database Approach

• Data Sharing
• Controlled Redundancy
• Data Independence

Database Management System (DBMS)

• Software package to create and maintain databases
• DBMS software + data = Database System
• Applications are sometimes included

Simplified database system environment

• Diagram illustrating the components of a simplified database system

Typical DBMS Functionality

• Defining the database
• Constructing the database
• Database manipulation (insertions, deletions, updates, querying, etc.)

Typical DBMS Functionality (Other features)

• Security measures to prevent unauthorized access
• Active processing to perform internal tasks
• Data presentation and visualization
• Database and application maintenance over lifetime

Example of a Database (with a Conceptual Data Model)

• Mini-world: Part of a UNIVERSITY environment
• Entities: STUDENTS, COURSES, SECTIONS, DEPARTMENTS, INSTRUCTORS

Example of a Database (with a Conceptual Data Model) Relationships

• Relationships: SECTIONS part of COURSE, STUDENTS take SECTIONs, COURSEs have prerequisite COURSES, instructors teach SECTIONs, COURSEs offered by DEPARTMENTS, STUDENTS major in DEPARTMENTS

Example of a Simple Database

• Example tables (COURSE, SECTION, GRADE_REPORT, PREREQUISITE) showcasing database structures

Thanks

This quiz covers the introduction to databases, focusing on the key concepts and definitions essential for understanding database management systems. Test your knowledge on database applications and the relational data model as outlined in Chapter 1. Perfect for students of IS212 at Minia University.