Database is a collection of interrelated data stored together with controlled redundancy to serve one or more applications in an optimal way. The data are stored in such a way that they are independent of the programs used by the people for accessing the data.
Database Management is a software system for manipulating databases.
Physical Database consists of Data Items, Relationships, Constraints and Schema.
Data Base Management has Five Primary Functions, Define, create and organize a database, Input data, Process data, Maintain data integrity and security and Query database.
Examples of DBMS include Microsoft Access, Oracle, IBM DB2, SQL Server and MySQL.
The DBMS software together with the Database is called a database system. It can be defined as an organization of components that define and regulate the collection, storage, management and use of data in a database. It is a system whose overall purpose is to record and maintain information.
Advantages of Database Systems Include, Controlled redundancy, Data consistency, Sharing of data, Improved data integrity, Improved security and .Data access is efficient.
Types of Database Models Include Hierarchical database, Network database, Relational database and Object-relational database.
SQL is a standardized query language for requesting information from a database.
Access is the database-management program, part of the Microsoft Office suite, that enables you to maintain databases.Its structure makes the information easy to select, sort, display, and print in a variety of formats.
In this section I learnt most about the types of database, what it is used for and to use Microsoft access which is an relational database. we did a table about Microsoft access which was very interesting and I learnt a lot in this lesson.
0 comments:
Post a Comment