Session 1
In this week we learned about database. We learned that database is the container or a collection of data. And it has four components: data, relationships, constraint, and schema….
Database management system: it’s software that create database. For example, Microsoft access
And then we learned that DBMS performs five primary functions: define, create and organize a database, input data, process data, maintain data integrity and security (it allows limited access of the database), and query database.
Later on, we moved to the Database system and this is different than data management system, and it is a computer based record keeping system.
We were exposed to the advantages of database system, it improves security, improves data integrity, controls redundancy and efficiency in accessing data.
There are four types of database model: Hierarchical database (organizes data in a tree structure “one to many”), network database (many to many relationship), Relational database (basically a table with rows: representing Field and columns: representing Record), and Object-relational database ( quite similar to relational database but this is one is highly object oriented language)
Session 2
We did a practical work creating a table form using Microsoft Access.
No comments:
Post a Comment