People Innovation Excellence

INTRODUCTION TO DATABASE SYSTEMS 4 SCU

Learning Outcomes

Explain the role of databases in organizations and information systems; Use SQL to construct, secure and access the database; Apply formal languages associated with the relational database model, including relational algebra, and relational calculus; Develop a relational database using database design methodology three main phases: conceptual, logical, and physical design; Use formal technique for producing a set of normalized relations that support the data requirements of an enterprise; Use the advanced SQL programming language in a DBMS environment; Develop a distributed DBMSs along with its transaction management and replication techniques; Use database management system in the web technology and mobile environment.

Topics

This course introduces the concept of information modeling, which emphasizes the importance of grouping the information into specific categories before it is transferred to the actual database design. Later in this course, an implementation phase is discussed to ensure the students are well aware of any implications that might develop from improper information modeling. In addition, this course also aims to introduce students to the concept of database design by predicting the use of future retrieval systems. Students understand that both a consideration of the data model and awareness of the retrieval system to be applied are required in designing a database. Consequently, new concepts are introduced, such as query processing and optimization, transaction processing concepts, and concurrency control techniques. This will lead students to understand the method of database tuning, functional dependencies, and normalization for RDB that will help them to understand further courses. This course also covers selected issues related to databases such as advanced SQL programming language (SQL/PSM and PL/SQL), cursor and stored procedures, techniques in transaction management, distributed DBMSs and replication, as well as data-warehousing concepts. The implementation of web technology and databases along with mobile databases will also be highlighted.

 


Published at : Updated

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9
Close