FinalExam Study Guide.docx - Metadata from a database may...

This preview shows page 1 - 3 out of 10 pages.

Metadata from a database may become data for another database.System development is a process that after it ends, it may start again.The Design View in Microsoft Access allows database designers to modify metadata in a database.A Word Document may have the following pieces of metadata:othe name of the person who created the document othe number of paragraphs in the document othe date in which it was createdThe following are correct statements regarding Traditional File Processing SystemsoIt is easier to implement for small systems oIt is difficult to use data inside one system within another system oDifferent systems may have the same data stored in incompatible formatsThe fact that a person’s name is stored in just one place in a database is an example of improved data consistencyIn an ERD, multivalued attributes are represented by surrounding attribute names with curly brackets { }.In an ERD, a derived attribute is represented by surrounding attribute names with square brackets [ ].The following are correct statements regarding ERDs,oThere could be more than one relationship between two entities. oA composite attribute must have more than one element of the composite.oAn associative relationship may replace having attributes on a relationship.The following are correct statements regarding cardinalities in relationships for ERDs:oA bar ( | ) and a crow’s feet next to an entity means that there should be one or more of this entity in the relationship.oA zero and a bar ( | ) next to an entity means that there could bezero or 1 of this entity in the relationship..oTwo bars ( | | ) next to an entity means that there must be 1 an only 1 of this entity in the relationship.
oTernary relationship: The diagram above obviously misses the relationship between Property and Owner. What kind of relationship will that be?oIn terms of cardinality, what kind of relationship would the Property and Owner relationship be?
oThe Property-Owner relationship has an attribute for the Percentage Owned. Where should this be attribute be located?
oIs there any other relationship missing that could be represented in the ERD? If so, which?
oWhere should the name of the real estate firm “Heisenberg & Associates”” be represented in this ERD?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture