database

DTA(M) Database Theory & Applications Quiz: Functional Dependency & Normalization Solutions [Part A: Functional Dependency Quiz] 1. __________ refers to an attribute or group of attributes mentioned in the left-hand side of the arrow in a Functional Dependency (FD). a) Discriminator b) Determinant c) Multivalued attribute d) All of the above Solution: Determinant. 2. In […]

DTA(M) Database Theory & Applications Lab 3 Tasks Task 1: Operational Anomalies You are given the following relation: Student 1.1: Identify an anomaly after updating the address of student with SID = 41; provide an explanation. 1.2: Identify an anomaly after dropping the subject ‘Maths’ from student with SID = 42; provide an explanation. 1.3:

DTA(M) Database Theory & Applications Lab 4 Tasks Task 1: Normalization to 3NF An engineering company supplies temporary specialized staff to bigger companies in the UK to work on their projects for certain amount of time. The relation R in Table 1 below lists the time spent by each of the company’s employees at other

DTA(M) Database Theory & Applications Lab 3 Tasks: Solutions Task 1: Operational Anomalies Solutions 1.1: Update anomaly: To update the address of a student (e.g., SID = 41), who occurs twice or more than twice in the relation, we need to update the Address column in all the corresponding rows, i.e., it requires a full