Database Management I

Back to: DATA PROCESSING SS 1

 

Welcome to class! 

In today’s class, we will be talking about database management. Enjoy the class!

Database Management I

The database is an application that is used to store information in a structured way. It is a collection of records or data in an organized form.

A database management system is a collection of computer software that enables users to define, create and maintain a database. A database management system (DBMS) is a computer application that interacts with the user, other applications and the database itself to capture and analyse data.

The general purpose of the database management system (DBMS) is designed to allow the definition, creation, querying and administration of the database. The DBMS serves as an interface between the database and end-users or application programs, ensuring that data is consistently organized and remain easily accessible. Database Administrators are those that control the database system. They also control the access and security aspects of the database.

Functions of DBMS

A DBMS makes it possible for users to create, edit and update data in database files. The functions also include

1. It creates security rules to determine the access right of users.
2. Concurrent access to the same database at the same time.
3. It improves the integrity of the data in the database.
4. It also provides a data dictionary for the description of data.

Evaluation

1. What do you understand by database management?
2. Who is a database administrator?

Examples of database management packages

There are varieties of a database management system. Some of these are:

1. Microsoft Access: it is a DBMS developed by Microsoft. It stores data in its own format based on the access jet engine. It has facilities like importing or linking directly to data stored in other databases.
2. MySQL: it is an open-source DBMS. One of the most popular DBMS.
3. Oracle: it is an object-relational database management system.
4. Microsoft SQL server: it was developed by Microsoft. The primary function of this software is to store and retrieve the data as requested by other applications, whether those applications are on the computer or running on another computer across the network.
5. Filemaker: it was begun as a MS-DOS based computer program. It is a cross-platform relational database management system.

Database terminologies

1. Rows: are the records.
2. Column: is vertical and labelled alphabetically.
3. Field: is a group of related characters in a file
4. Character: is a single symbol in a file.
5. Record: is made of a number of fields that are related together and treated as an entity.

General evaluation

1. List other types of database applications apart from Ms-Acess.
2. List three database terminologies and explain them.
3. What is a record in database?
4. Mention two database packages and briefly on them.

Reading assignment

Data Processing for Senior Secondary Education by HiiT Plc.

Weekend assignment

1. The person that controls the entire database system is called ___     A. database manager.    B. database analyst       C. computer Analyst     D. database administrator.
2. A collection of computer software that enables users to define, create and maintain a database is referred to as ___    A. database program      B. database management     C.  computer software      D. database pro
3. One of these DBMS began with MS-Dos.    A.   MS-Access    B. MySQL     C. Corel   D.   Filemaker
4. The general-purpose database management system (DBMS) is designed to allow all except one. definition B. creation, C. querying D. multiplying
5. Concurrent in database management means….     A. to access by many people at once   B.   One person at a time      C. both A and B      D.   none

Theory

1. List and explain three examples of DBMS.
2. List three functions of DBMS.
3. Compare Row and Record.

 

In our next class, we will be talking more about Database Management.  We hope you enjoyed the class.

Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible.

Ready to make school management and growth easy? Book your free onboarding session now

Get more class notes, videos, homework help, exam practice on Android [DOWNLOAD]

Get more class notes, videos, homework help, exam practice on iPhone [DOWNLOAD]