Relational Database Design
The code for MS Teams is: h4dy8pd2
SCHEDULE
You can find the schedule here.
LOCATION
Course room: A101
Laboratory / Seminar room: C310
FSEGA Building, Strada Teodor Mihali 58-60, Cluj-Napoca 400591
ATTENDANCE
To attend the exam in the examination / resit examination periods, a student must have at least 12 laboratory attendances and at least 5 seminar attendances.
GRADING
written exam (W) – 50%
practical exam (P) – 25%
lab grade (L) – 25%
* requirements to pass: W >= 5, P >= 5
* practical exam: weeks 13/14
LAB
At most 2 assignments can be delivered / lab.
One week of delay = 0.5p penalty.
Lab assignments cannot be delivered in: week 13, week 14, the exam
period.
COURSE
C1: What is a Database? Different Types of Databases
C2: Benefits of Relational Databases
C3: Data Modelling Process
C4: Identifying Entities. Finding Exceptions to the Rule
C5: Normalisation. First Normal Form
C6: Second Normal Form
C7: Third Normal Form
C8: Data Types and Precision
C9: Integrity Constraints. Naming Conventions
C10: Lookup Tables and Auditing
C11: Implementation: part 1
C12: Implementation: part 2
C13: Invited lecture: to be decided
C14: Invited lecture: to be decided