Page 466 - Computer_Science_F5
P. 466
Table 8.4: Company chief executive but the dependent attribute can have
officers’ details
multiple independent values.
Company CEO BirthDate Step 2: Identify a Real-Life
Microsoft Satya Nadella 01/2/1967 Scenario
FOR ONLINE READING ONLY
Google Sundar Pichai 12/6/1972 Observe your environment to find an Chapter Eight: Databases and Database Management Systems
Facebook Mark Zuckerberg 07/9/1984 example where several independent
attributes relate to a single entity.
It follows that {Company} -> {CEO}
(if we know the company, we know its Step 3: Create a Table
CEO’s name). {CEO} -> {Birthdate}; if Based on your observation, design
we know the CEO, we know the Birthdate. a single table that demonstrates
Therefore, if the rule of transitive multivalued dependency
dependency: {Company} -> {Birthdate} characteristics.
should hold, it will make sense because
if we know the company’s name, we can Deliverable
know the CEO’s birthdate.
Submit the table demonstrating
multivalued dependencies, including
Activity 8.6: attributes and sample data. Provide
Exploring multivalued dependencies a brief explanation of the scenario
in databases that inspired your table design and
how multivalued dependencies are
Aim: illustrated. Make sure you document
Explore multivalued dependencies your findings in a portifolio.
by creating and analyzing a table that
exemplifies these characteristics.
Normalisation
Materials:
1. Computer with database software (a) Meaning of normalisation
(Such as MySQL, PostgreSQL, or Normalization organises data into
any DBMS tool) cohesive groups and establishes
2. Access to a DBMS relationships to minimize redundancy
3. Data sets or sample data to create and prevent anomalies like insertion,
the table update, and deletion issues. Its goal is
to ensure data consistency, optimise
Instructions: data retrieval, and avoid the need
Step 1: Study Multivalued for frequent database redesigns.
Dependencies By analyzing schemas based on
Learn about multivalued dependencies functional dependencies and primary
where one attribute determines another, keys, normalization follows structured
457
Student’s Book Form Five
Computer Science Form 5.indd 457 23/07/2024 12:34
