Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Key constraints,”A relation must have[…]
Read moreLatest Posts
Surrogate keys,”(those with no business meaning such as 001, 002
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review. Surrogate keys,”(those with no[…]
Read moreNatural/ business key
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Natural/ business key Come from[…]
Read moreKey properties of relational modeling,”Values are atomic (i.e., a data cell cannot contain multiple values)Values in a given column are of the same domain/type (e.g., float)No rows contain completely duplicate dataThe order of rows and columns is completely irrelevantThe names of every relation are unique and within relations
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Key properties of relational modeling,”Values[…]
Read moreThe typical flow when designing a database involves:,”Developing an ER diagramMapping the ER diagram into the relational modelNormalizing to avoid anomalies, reduce redundancy, and increase integrityInstantiating the database (e.g.
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.The typical flow when designing[…]
Read moreT/F? Supertype/subtype relationships can span multiple levels
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.T/F? Supertype/subtype relationships can span[…]
Read moresubtype discriminators,”Hourly- HSalaried- SConsultant- CThe letters H, S
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.subtype discriminators,”Hourly- HSalaried- SConsultant- CThe[…]
Read moreDisjointess contraint:
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Disjointess contraint: determines whether a[…]
Read morePartial Specialization Rule,”a supertype may have a subtypeIndicated with a single line (e.g.
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Partial Specialization Rule,”a supertype may[…]
Read moreSubtypes and supertypes,”specialization/ generalization All attributes of a supertype are inherited by each of its subtypes, including a common identifierSubtypes have their own unique attributes beyond those of the supertypeIndicated using a circle and connecting lines
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Subtypes and supertypes,”specialization/ generalization All[…]
Read more