What is metadata? Give two examples. Give two examples of d

What is metadata? Give two examples. Give two examples of database management systems. Define: Intranet, Extranet, and Internet. What is the purpose of each one? What’s the purpose of normalization? What’s the purpose of denormalization? List three advantages of the database approach over file-processing systems. What are major database development steps? What are the three basic constructs of an E-R model? Define entity type and entity instance. Give an example for each. Define strong entity type and weak entity type. Give an example for each. Define composite attribute, simple attribute, multivalued attribute, derived attribute. Give an example for each. Degree of a relationship is defined as “the number of entity types that participate in a relationship.” What are the three most common relationship types according to the degree of a relationship? Give an example for each. Define cardinality constraint. List four types of cardinality constraints and given an example for each. Define primary key, composite key, foreign key, candidate key, and recursive foreign key. Define generalization and specialization. Give an example for each. Define completeness constraint (total specialization rule, partial specialization rule) and disjointness constraint (disjoint rule, overlap rule). Define subtype discriminator, and give an example. Relation is defined as “a named two-dimensional table of data.” However, not all tables are relations. Relations have several properties that distinguish them from nonrelational tables. What are they? Define entity integrity rule and referential integrity constraint. Define functional dependency, and give an example. Define partial functional dependency and transitive dependency. Define 1NF, 2NF, and 3NF. Define physical record, page, and blocking factor. Define horizontal partitioning and vertical partitioning. Sequential, indexed, and hashed are three basic file organizations. Define each of them. Consider the entity sets and attributes shown in the table below. Place a checkmark in one column in each row to indicate the relationship between the far left and the far right columns. Entity Set has a relationship with has an attribute is a specialization of is a generalization of Entity Set or Attribute Student Person Animal Horse Employee SSN School Student Consider the following relation R, and assume that each of the following letters represents an attribute in R: R (A, B, C, D, E, F) Suppose the following dependencies exist: A, B -> C, D, E, F B -> D E -> F Your assignment is as follows: Draw a relational schema for your 1NF relation and diagram the functional dependencies.Draw a relational schema for your 2NF relations, diagram the functional dependencies, and show the referential integrity constraints.Draw a relational schema for your 3NF relations, diagram the functional dependencies, and show the referential integrity constraints.

Place New Order
It's Free, Fast & Safe

"Looking for a Similar Assignment? Order now and Get a Discount!

Scroll to Top