Upgrade to remove ads Show Only A$47.99/year
Terms in this set (30)The term "____" is used to label any condition in which one or more optional relationships exist. optionality In the ERD, cardinality is indicated using the ____ notation. (min, max) Connectivities and cardinalities are usually based on ____________________ rules. business A person's social security number would be an example of a(n) ____________________ attribute. single-valued In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity. existence-dependent In an ER diagram, primary keys are indicated by ____. underlining The Crow's Foot model is less implementation-oriented than the Chen model. False Some attributes are classified as ____. Correct simple Relationships operate only in one direction. false The word "entity" in the ER model corresponds to a table. true The hierarchical data model was developed in the ____. 1960s If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A). True A(n) ____ is bidirectional. relationship You should always load data from the 1 side of a 1:M relationship. True A ____ relationship exists when two entities are associated. binary A(n) ____ is anything about which data are to be collected and stored. entity The relational database model enables you to view data ____ rather than ____. logically, physically The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity. mandatory In a database context, a(n) ____ indicates the use of different names to describe the same attribute. synonym Referential and entity integrity are two names for the same thing. False Granularity refers to ____. Correct the level of detail represented by the values stored in a table's row A table is in 2NF if it is in 1NF and it includes no partial dependencies. True It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key. foreign In _________________________ no row may contain two or more multivalued facts about an entity. Fourth normal form (4NF) A table is in BCNF if every determinant in the table is a foreign key. False Atomic attributes are attributes that can be further divided. False With parrtial dependencies, data redundancies occur because every row entry requires duplication of data. True In a real-world environment, we must strike a balance between design integrity and ____.
flexibility Data redundancy produces ____. data integrity problems Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to go in the normalization process. three Students also viewedChapter 419 terms clnyce FIT2094-L313 terms Kade_Wu IT Quiz 440 terms MANDLAZI Database Chapter 4 Quiz25 terms amanda_ebner3 Sets found in the same folderQuiz #2 - Fill in the Blanks47 terms jaetranx3 Chapter 3 (part 2)20 terms taniajohst Quiz Chapter 620 terms megsb20 Database Chapter 271 terms cppbroncosstudystuff Other sets by this creatorA+ Exam94 terms mtrench623 MBUS 304 Midterm48 terms mtrench623 MBUS 300 Managerial Chapter 915 terms mtrench623 MBUS 300 Chapter 3 Managerial11 terms mtrench623 Verified questions
engineering Tool life can be almost infinite at low cutting speeds. Would you then recommend that all machining be done at low speeds? Explain. Verified answer
chemistry Draw Fischer projections of the following molecules, placing the carbonyl group at the top in the usual way. Identify each as a d or l sugar. Verified answer
physics When a body is moved from sea level to the top of a mountain, what changes-the body's mass, its weight, or both? Explain . Verified answer
physics A crate is siding down a ramp that is inclined at an angle of $$ 38.0^\circ $$ above the horizontal. The coefficient of kinetic friction between the crate and the ramp surface is 0.600. Find the acceleration of the moving crate. Verified answer Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 solutions Other Quizlet setsDatabase exam 130 terms andrew_ripley7 Exam 2 [MGMT-382]270 terms DecetopPlus admin test 153 terms mikkisickle Which one of the following is an example of an optional attribute?"Middle name" of a person is an example of optional attribute.
What is an attribute CIS?Attribute. A characteristic of an entity or object. An attribute has a name and a data type.
What is the term that describes the number of times that an object can participate in a relationship?Here cardinality represents the number of times an entity of an entity set participates in a relationship set. Or we can say that the cardinality of a relationship is the number of tuples (rows) in a relationship. Types of cardinality in between tables are: one-to-one.
Which attribute Cannot be subdivided?Simple attribute :
An attribute that cannot be further subdivided into components is a simple attribute.
|