Infopaket

Database Organization

ОК.26

Обов’язкова дисципліна для ОП

First

2023/2024

5 Semester

4

Program results are: a) Know the definition of a database (DB), management system databases (DBMS), business scenarios and industry examples of database application b) Know the basic concepts related to the relational database: unique identifiers, objects and attributes, connections c) Know the rules of table normalization d) Know the stages of database design e) Know the Oracle SQL Developer Data Modeler interface f) Know the instructions for using Oracle Application Express g) Be able to identify errors in tables and normalize them based on NF1, NF2, NF3 h) Be able to create relationships between objects (ERD diagrams) i) Be able to create conceptual, logical and physical data models using Oracle SQL Developer Data Modeler j) Be able to organize a database using Oracle Application Express k) Be able to create queries to an organized database in the Oracle Application Express cloud environment

Full-time form

Successful mastering of disciplines: – "Fundamentals of programming"; – "Computer architecture"; – "Programming technologies"; – "Theory of algorithms".

As part of studying the discipline, students get acquainted with the basic principles of database organization. The structure of the course involves the study of basic concepts: database, types of databases, object, subject, relationship, attribute, foreign key, internal key, unique identifier, query language, transactions, creating tables, merging tables. As part of studying the discipline, students learn to solve the following problems: – description of the purpose of the relational database; – description of key business requirements presented during database development; – use of data modeling to create a relational database architecture; – development of an "object-relationship" diagram (ERD) for data modeling; – use of Oracle SQL Developer Data Modeler to build ERD diagrams; – comparison of the physical model with the ERD diagram; – creation of a physical model from a logical model (ERD); – writing, executing and saving SQL statements in Oracle Application Express The curriculum is project-oriented, the program is recognized in the field of certification. Based on the results of training, students pass the final exam for the course "DFo Database Basics for Training - CPD" and receive an Oracle Academy certificate.

Lectures, laboratory activities, individual work.

The current assessment is conducted in the form of a survey of students on the topics of previous lectures, topics of practical and laboratory works or topics of homework, intermediate tests on the topics of the course "DFo Database Basics for Training - CPD" Oracle. Students perform 4 practical and 4 laboratory works, which are evaluated from 5 to 8 points per work. The assessment is reduced by 1-2 points for the completion and protection of works in the overdue period. No more than 2 works can be defended at one time. Intermediate testing is valued from 8 to 16 points for successful completion of tests (with a score of more than 80%) on the topics of 6 sections of the course "DFo Database Basics for Training - CPD" Oracle. If the intermediate test is not passed, no points are awarded and the student is not admitted to certification. The total amount for the semester is from 48 to 80 points. Final evaluation in the form of credit: is 20 module points (20% of the total rating).

Ukrainian