Technologies of database designing for Computer Engineering
Field of study: Computer Engineering
Assessment methods: Exam (for the second year of study)
|
Contents of the Education Lectures |
|||||||
|
Item number
|
Study programme
|
Amount of hours
|
|||||
|
1
|
Organizational classes, conditions of the credit |
1
|
|||||
|
2
|
Review of relational databases. Database model – introduction. Logical data models. Relationships and functions. |
4
|
|||||
|
3
|
Definitions: instance, schema, table, rows etc., DML or DDL, ERD. | 4 | |||||
| 4 | Mission Critical Applications, VLDB, Selecting a DBMS. Relational Databases Design. Relations: 1 to 1, 1 to many, many to many. Planning. Replication. |
2
|
|||||
|
5
|
Indexes in data bases |
2
|
|||||
|
6
|
SQL – Structured Query Language. Data Definition Commands. Data Types. SQL Constraints. SQL Indexes. |
5
|
|||||
|
7
|
SQL – Structured Query Language. Data Manipulation Commands. Arithmetic Operators and Special Operators. Aggregate Functions and Virtual Tables. Joining Database Tables |
5
|
|||||
|
8
|
DDL – Data Definition Language. Data Model. Introduction to Object-oriented databases. OQL. ODL. Data Warehouse. |
4
|
|||||
|
9
|
Technologies of database designing Exam 0 (for the second year of study) – Date on the Moodle platform. Technologies of database designing Exam 1 (for the second year of study) – Date on the Moodle platform. Technologies of database designing Exam 2 (for the second year of study) – Date on the Moodle platform. |
2
|
|||||
Entries to index/USOS System: –
Organisational Remarks:
1. An Final Exam is scheduled at the end of series of lectures.
2. Only three approaches to pass the lectures are possible. Positive evaluations cannot be corrected (however there are some exceptions permitted J).
3. In urgent cases, it is possibile to contact with me via e-mail. The e-mail should be signed.
4. After an assignment each student has the possibility to look exam during consultations.
5. A student loses chance to pass the course in case of absence on the final Exam.
6. Please monitor this page just before classes, because in case of any rearrangements of lectures, a brief information on this topic will appear here.
Assessment schedule:
08.01.2024 Database modelling Exam 0
15.01.2024 Database modelling Exam I
22.01.2024 Database modelling Exam II
The Exam exempts from obtaining a grade of 5.0 from labs – the evaluation of all Reports will be above 4.65.
Information about servers availability for LAB classes:
Parameters for the ELARA server: IP: 217.173.198.135; Port: 1521 (changed!) Service name: tpdb (Attention, change here! It’s not SID like last time). MS SQL Serwer and Oracle Database 19c are running on the ELARA server. If a new account is created, students log in by default as login: s12345, password s12345, where 12345 is the index number. The password is the same as the login. Students should change their password right after logging in for the first time. If it turns out that an account does not work or does not have sufficient rights, then the Student sends an e-mail from the address @ student.po.edu.pl to Dr. Ewelina Piotrowska.
ORGANIZATIONAL REMARKS AND THE DEVELOPMENT OF THE LAB!
1. Student obtains a total of four LAB grades, but the last one has a weight of x2. Three report grades and one practical implementation grade.
2. A delay in submitting a given Report by one week lowers the grade for a given part of the work by one notch. The stages finally completed cannot be improved.
3. Jobs that are copies of others will be rejected. Collective responsibility.
4. The models should be made in a legible way, so that the thought of the author of the work can be easily identified on the printout.
5. If a given Student is not satisfied with the proposed final grade in the subject, it is possible to write a retake test.
6. Student must pass each of the LAB stages, min. to 3.0 for final credit.
Labs – Database modeling for full-time 1st cycle studies
LAB 0 – only topic
Lab topics:
PART 0. Selection of topics for modeling tasks in database management systems – by:
Each Student individually informs the tutor about the topic proposes. If the student does not have an idea, the tutor proposes the topic himself. The database should contain at least 5 tables.
LAB I – Report I
PART I. Development of a fragment of reality – a verbal description in English of the modeled databases – by:
1st assessment – the Student provides the teacher with a verbal description along with the topic on an A4 page for evaluation. Please describe in detail the correlations between the distinguished units – entities. The returned document should be signed with the Creator’s data (name, surname, group).
To work on the exercises – reports, use the material provided during the lecture. In addition, real consultation is possible.
Works should be sent in pdf format to the following e-mail address: s.paszkiel@po.edu.pl.
VERY IMPORTANT! Name the file to be sent, please name by key:
Course_Name_Surname_Name_Report_I
The report name and author name should appear in the file.
LAB II – Report II
PART II. Creating a conceptual model for a designed database – Entity Relationship Diagrams (ER)
Verification of the conceptual model for the designed database (ER) – by:
2nd assessment – The student submits to the teacher for assessment in a printed form the conceptual model of the database – the ER model. Please make the model according to the convention given in the lecture. The model should not contain data types, foreign keys, or proxy tables for many-to-many relationships. The model should be: signed (author’s name and surname, group number), the returned document should contain the name of the environment (program) in which it was made and the name of the topic carried out by the Student.
To work on the exercises – reports, use the material provided during the lecture. In addition, real consultation is possible.
Works should be sent in pdf format to the following e-mail address: s.paszkiel@po.edu.pl.
VERY IMPORTANT! Name the file to be sent, please name by key:
Course_Name_Surname_Name_Report_II
The report name and author name should appear in the file.
LAB III – Report III
PART III. Creating a Physical Model for the Project Database (RDB)
Verification of the physical model for the designed database (IDM) – by:
3rd assessment – The student submits to the teacher for evaluation in a printed form the physical model of the proposed database – the RDB model. The relationships in the model should be finally verified and strictly defined. The model should be: signed (author’s name and surname, group number), the returned document should contain the name of the environment (program) in which it was made and the name of the topic carried out by the Student.
To work on the exercises – reports, use the material provided during the lecture. In addition, real consultation is possible.
Works should be sent in pdf format to the following e-mail address: s.paszkiel@po.edu.pl.
VERY IMPORTANT! Name the file to be sent, please name by key:
Course_Name_Surname_Name_Report_III
The report name and author name should appear in the file.
LAB IV – practical work – Report IV
MODULE I: structure and indexes
MODULE II: transactional processing – examples of SQL queries, procedures (e.g. generator to populate the tables in the database with data), triggers (e.g. validation of data entered into tables in the database). The student should implement: min. 5 SQL queries, min. 3 procedures; min. 3 triggers.
Verification of the physical implementation – by:
4th assessment – The student presents to the tutor for the assessment of the physically developed implementation of the designed database in database management systems – RDBMS – Oracle Data Base – Oracle SQL Designer and MS SQL Server – MS DBMS SQL program, containing: indexes, triggers, procedures, transactions. The ability to subjectively compare DBMSs is also required. The grade for this module of classes is counted twice for the final grade and depends on the advancement of the procedures and triggers presented.
If the task is performed only under one of the RDBMSs, then max. the final grade to be obtained from the project is 4.0.