Week 7: Apply relational database design approach and implement it using Microsoft Access or other DBMS

DATABASE. It was turn to learn about database, according to the definition which we have seen in that class 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 System is a software system for manipulating databases.
Than, we learn about Database management Systems:

•Define, create and organise a database: The DBMS establishes the logical relationships among different data elements in a database and also defines schemas and subschemas using the DDL.

•Input data: It performs the function of entering the data into the database through an input device (like data screen, or voice activated system) with the help of the user.

•Process data: It performs the function of manipulation and processing of the data stored in the database using the DML.

•Maintain data integrity and security: It allows limited access of the database to authorised users to maintain data integrity and security.

•Query database: It provides information to the decision makers that they need to make important decisions. This information is provided by querying the database using SQL

Next, we learned about how to make database using Microsoft access: 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.