Database System Design

A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database.

A database is an organized pool of logically-related data. Data is stored within the data structures of the database. A DBMS is a suite of computer software providing the interface between users and a database or databases. A DBMS is a shell which surrounds a database or series of databases and through which all interactions take place with the database. The interactions catered for by most existing DBMS fall into 4 main groups:

  • Data Definition. Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.
  • Data Maintenance. Inserting new data into existing data structures, updating data in existing data structures, deleting data from existing data structures.
  • Data Retrieval. Querying existing data by end-users and extracting data for use by application programs.
  • Data Control. Creating and monitoring users of the database, restricting access to data in the database and monitoring the performance of databases.

Both a database and its DBMS conform to the principles of a particular data model. Data models include the hierarchical data model, the network data model, the relational data model and the object-oriented data model.

Probabilities and Statistic

This subject equips you with the fundamental concepts of statistics to organize, summarize, analyses, interpret, present and draw conclusions based on data. You will learn to illustrate the concept of sampling distribution, calculate interval estimates, perform hypothesis testing and analyzing relationships between variables. In particular, you will be exposed to methods of data analysis that are useful in business environments. You will also learn to use statistical software to analyze data.

Data Communication

This course, students will explore and understanding about data transmission, line configuration, transmission mode, network topology, type of network, know how to use the IP Address in the Network system, understanding the OSI Reference model. At the end students can know around the data transmission in the network system.

Mathematics for Computer (Mathematics Analyze)

This subject equips you with the ability to use mathematics and mathematical processes as tools for developing algorithms in computing and other real-life applications. It also serves to help you develop confidence and competence in reasoning, proof and induction. This subject introduces you to the fundamental concepts of mathematics needed for the other core computing subjects.