Introduction to DEC40073

Introduction to DEC40073 Database System

        A database can be defined as a shared collections of interested data designed to meet the varied information needs of an organization. A database is integrated, previously distinct data files have been logically organized to eliminate or reduce redundancy and to facilitate data access. All qualified users in the organization have access to the same data for use in a variety of activities. It also interrelated. Structured in a manner that is logically meaningful to the organization.

        There are a number of advantages to the database approach. These are discussed in more detail in the topic Database Systems. Some of the advantages of a database system are summarized below:

1. Data management - A DBMS provides a mechanism for easier management of the data held by an organization.
2. Data independence - In a database system the data is held independently of the application programs that use it.  Changes to the data or the way it is stored will not necessarily affect the programs that use the data. 
3. Data consistency - A database system is designed to reduce redundancy. Items of data are ideally only stored in one location. When updates are made to data, changes should only need to be made to this one location. This greatly improved the consistency of the results of queries made on the database.
4. Data Sharing - The collection of data in a central data repository and managed by a DBMS allows the data to be shared by several users and applications.
5. Reduce maintenance - A number of tools for maintaining the data are already built in to most DBMS.  Tools may include report generators, query languages, form generators, code checkers, data dictionaries and maintenance logs.

Components of database

A database consists of:

Upon completion of this course, students should be able to:

1. Apply the basic concepts of database model using entity-relationship diagram and
   translating completed data models by applying normalization technique in logical database designs. (C3, PLO1, PLO2, PLO5, PLO9)
2. Solve assigned problems using critical thinking by developing a new database application. (C3, PLO1, PLO2, PLO5, PLO9)
3. Manipulate correctly Structured Query Language (SQL) for database using a database management system during practical work sessions. (P4, PLO1, PLO2, PLO5, PLO9)
4. Demonstrate good oral communication skill in group presentation on the database application developed based on the assigned problem. (A3, PLO1, PLO2, PLO5, PLO9)