This course introduces concept and terminology in database system, like architecture database, relational model, database planning, normalization technique, ER Modeling, Structure Query Language (SQL), security issues in database environment, and database technologies like Online Transaction Processing concept. It gives student basic knowledge about how to create dan modifies tables that appropriate to the requirement of organization.
Please note that the language used in this course is Indonesian. We are working to translate it into English.
This lecture explains about introduction of database, differentiation between file-based system and database system, why we should move from file-based to database system, the importance of database system, and major components of the DBMS environment.
This lecture explains about database technical environment, the function of DBMS, and three level of architecture.
Three levels of architecture consist of:
Introduction to Database Environment
This lecture explains the planning, design, and administration of database. It also explains main stages of the database system development life-cycle.
Database life-cycle consists of:
This lecture explains SQL data definition and the integrity constraint using SQL.
Integrity constraint consists of
This video explains the types of threat that can affect a database system and how to protect a computer system using computer based control.
Database security involves measurement to avoid:
The structural database design using SQL
This lecture explains about basic technical to manipulate (update) database using SQL statement.
The basic SQL statements for updating database are:
This lecture explains about advanced technical to manipulate (aggregate) database using SQL statement.
The advanced SQL statements for aggregating database are:
The operation of manipulation data using SQL
This lecture explains about the functional dependencies and normalization using functional dependencies to group attributes.
The process (level) of normalization consists of:
This lecture explains about the Entity Relationship (ER) modelling in database design and how to resolve problem with ER model by using 3 types of key:
This lecture explains about the limitations of the basic concepts of the Entity Relationship (ER) model and the requirements to represent more complex applications. ER model is divided into 2 type of class:
Database Analysis and Design
Bina Nusantara University (BINUS University) is a private university in Indonesia. The vision of BINUS University is a world-class university … in continuous pursuit of innovation and enterprise. The mission of BINUS University is to contribute to the global community through the provision of world-class education. BINUS University has 7 faculties and more than 30 programs for Undergraduate, Magister, and Doctorate level, 25000 students, and 6 campuses. Based on QS Stars ranking, BINUS University achieves 3 of 5 stars with ranking of number 11 in Indonesia (number 1 for private university) and number 301-350 in Asian.