Exam (elaborations) INF3703 Assignment 2 (COMPLETE ANSWERS) 2024 - DUE 28 June 2024 • Course • Databases II - INF3703 (INF3703) • Institution • University Of South Africa • Book • Principl...
Exam (elaborations) INF3703 Assignment 2 (COMPLETE ANSWERS) 2024 - DUE 28 June 2024 • Course • Databases II - INF3703 (INF3703) • Institution • University Of South Africa • Book • Principl...
a. Difference between a column constraint and a table constraint:
A column constraint applies only to a single column within a table and is used
to enforce data integrity specific to that column (e.g., NOT NULL or UNIQUE
constraints on a column).
A table constraint applies to multiple columns within the table or even the entire
table, allowing more complex integrity checks (e.g., PRIMARY KEY, FOREIGN
KEY, or CHECK constraints that might involve multiple columns).
,b. Disjoint Subtype and Example:
A disjoint subtype is a subtype in a specialization hierarchy where an entity instance
can belong to only one subtype. If an entity is part of one subtype, it cannot be part of
another. For example, in a personnel database, an Employee could be either a
FullTimeEmployee or a PartTimeEmployee, but not both, making FullTimeEmployee
and PartTimeEmployee disjoint subtypes.
c. Three Join Types in the OUTER JOIN Classification:
1. LEFT OUTER JOIN: Returns all records from the left table and the matched
records from the right table. If no match is found, NULL values are returned for
columns from the right table.
2. RIGHT OUTER JOIN: Returns all records from the right table and the matched
records from the left table. If no match is found, NULL values are returned for
columns from the left table.
3. FULL OUTER JOIN: Returns all records when there is a match in either the left
or the right table. If no match is found, NULL values are returned for the columns
from the table without a match.
d. Strong (or Identifying) Relationship:
A strong (or identifying) relationship exists when a child entity's existence is
dependent on its parent entity, and the primary key of the parent entity is also part of the
child entity's primary key.
e. Why a table with a single-attribute primary key is automatically in 2NF when in
1NF:
When a table's primary key consists of a single attribute, it cannot have partial
dependencies (where a non-key attribute depends on part of a composite key), as
there’s only one attribute in the primary key. Thus, the table is automatically in 2NF if it
is in 1NF.
f. Metadata:
Metadata is data that describes other data. It provides information about the structure,
, organization, and characteristics of data, such as data types, data lengths, and data
relationships.
g. Physical Independence in Data Models:
Physical independence is the ability of a data model to remain unaffected by changes
in the physical storage structures or devices. This allows the database to be modified at
the storage level without impacting the logical data structure or application level.
Question 3
a. Transfer the Unnormalized Form to First Normal Form (1NF)
Normalization to 1NF:
In 1NF, there should be no repeating groups, and each attribute must contain atomic
values. Since each row already contains atomic values and no repeating groups, the
table is in 1NF as shown above.
b. Transform the Relation into Second Normal Form (2NF)
Requirements for 2NF:
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur LIBRARYpro. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €2,66. Vous n'êtes lié à rien après votre achat.
