Database Management Systems: Concept, Advantages, Disadvantages, and Data Models, Assignments of Computer science

Download Database Management Systems: Concept, Advantages, Disadvantages, and Data Models and more Assignments Computer science in PDF only on Docsity!

Database Concept

Database

• (^) A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
• (^) Manual Database
• (^) Computerized Database

Examples of Database Applications

• (^) Computerized library systems
• (^) Automated teller machines
• (^) Flight reservation systems
• (^) Computerized parts inventory systems

DBMS Examples

• (^) MySQL
• (^) Microsoft Access
• (^) SQL Server
• (^) FileMaker
• (^) Oracle
• (^) RDBMS

Disadvantages of DBMS

• (^) Complex and Size
• (^) Cost of DBMS and additional hardware cost
• (^) Performance problem
• (^) DBMS system works on the centralized system

Data Models

• (^) Data models define how the logical structure of a database is modeled
• (^) Data models define how data is connected to each other and how they are processed and stored inside the system.

Example of Data Models

• (^) Networking Data Models

Example of Data Models

• (^) Relational Data Models

Types of Attributes

• (^) Simple attribute − Simple attributes are atomic values, which cannot be divided further. For example, a student's phone number is an atomic value of 10 digits.
• (^) Composite attribute − Composite attributes are made of more than one simple attribute. For example, a student's complete name may have first_name and last_name.

Types of Attributes

• (^) Derived attribute − Derived attributes are the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database.
• (^) Single-value attribute − Single-value attributes contain single value.
• (^) Multi-value attribute − Multi-value attributes may contain more than one values.