ログイン

DATABASE 2-5 MOD
25問 • 1年前
  • iam noone
  • 通報

    問題一覧

  • 1

    In mapping a unary relation, it is required to have another relation and the identitter of the superior entity will be taken as Foreign key.

    False

  • 2

    In mapping associative entities, the default primary key for the association relation is composed of the primary keys of the two

    true

  • 3

    In mapping binary relations, primary key on the mandatory side becomes the foreign key on optional side when it is____

    1.1

  • 4

    In mapping relations, you need to consider its cardinality.

    true

  • 5

    In transforming ERD to relations, use the simple component attributes for composite attributes

    true

  • 6

    In transforming ERD to relations, if there is a multivalued attribute,another relation will be created and the identifier of the superior entity will be also its identher.

    false

  • 7

    In ER diagram, there are three business rules for every relationship.

    false

  • 8

    Identifier can ba a combination of attributes that can distinguish each occurrence of an endly.

    true

  • 9

    in mapping binary relations. you need to create a new relation with the primary keys of the two entities as primary key when it is ____

    M:M

  • 10

    In mapping binary relations, the Primary key on the one side becomes the foreign key on the many side when it is

    1:M

  • 11

    This symbol used to indicate that the attribute is multivalued?

    []

  • 12

    A person's name, birthday, and social security number are all examples of:

    attributes

  • 13

    The total quiz points for a student for an entire semester is a(n)______ attribute

    derived

  • 14

    A business rule is a statement that defines or constrains some aspect of the business.

    true

  • 15

    Which of the following is NOT a characteristic of a good business rule?

    inconsistent

  • 16

    In an E-R diagram, an associative entity is represented by a rounded rectangle.

    true

  • 17

    A business rule is a statement that defines or constrains some aspect of the business

    True

  • 18

    An entity type whose existence depends on another entity type is called a ______entity

    Weak

  • 19

    An attribute that must have a value for every entity (or relationship) instance is a(n):

    required attribute

  • 20

    An entity type name should be all of the following EXCEPT:

    as short as possible

  • 21

    The common types of entities are:

    all of the choices

  • 22

    An attribute that can be broken down into smaller parts is called a(n)_______attribute.

    composite

  • 23

    Data names should always relate to business characteristics

    true

  • 24

    Data, rather than processes, are the most complex aspects of many modern information systems.

    true

  • 25

    A business rule should be internally consistent.

    true

  • Data Structure (history)

    Data Structure (history)

    iam noone · 64問 · 1年前

    Data Structure (history)

    Data Structure (history)

    64問 • 1年前
    iam noone

    Linear Data Structure

    Linear Data Structure

    iam noone · 43問 · 1年前

    Linear Data Structure

    Linear Data Structure

    43問 • 1年前
    iam noone

    Searching for Algorithms

    Searching for Algorithms

    iam noone · 22問 · 1年前

    Searching for Algorithms

    Searching for Algorithms

    22問 • 1年前
    iam noone

    Linked list/ Trees and graphs

    Linked list/ Trees and graphs

    iam noone · 51問 · 1年前

    Linked list/ Trees and graphs

    Linked list/ Trees and graphs

    51問 • 1年前
    iam noone

    Sorting algorithms

    Sorting algorithms

    iam noone · 41問 · 1年前

    Sorting algorithms

    Sorting algorithms

    41問 • 1年前
    iam noone

    INTRO TO MS ACCESS(database)

    INTRO TO MS ACCESS(database)

    iam noone · 19問 · 1年前

    INTRO TO MS ACCESS(database)

    INTRO TO MS ACCESS(database)

    19問 • 1年前
    iam noone

    Introduction To Java Programming Language

    Introduction To Java Programming Language

    iam noone · 80問 · 1年前

    Introduction To Java Programming Language

    Introduction To Java Programming Language

    80問 • 1年前
    iam noone

    Mod 2: Comp Prog

    Mod 2: Comp Prog

    iam noone · 55問 · 1年前

    Mod 2: Comp Prog

    Mod 2: Comp Prog

    55問 • 1年前
    iam noone

    COMP PROG MIDTERM

    COMP PROG MIDTERM

    iam noone · 42問 · 1年前

    COMP PROG MIDTERM

    COMP PROG MIDTERM

    42問 • 1年前
    iam noone

    FUNDAMENTALS OF DATABASE (Lesson 1)

    FUNDAMENTALS OF DATABASE (Lesson 1)

    iam noone · 31問 · 1年前

    FUNDAMENTALS OF DATABASE (Lesson 1)

    FUNDAMENTALS OF DATABASE (Lesson 1)

    31問 • 1年前
    iam noone

    FUNDAMENTALS OF DATABASE (part2)

    FUNDAMENTALS OF DATABASE (part2)

    iam noone · 33問 · 1年前

    FUNDAMENTALS OF DATABASE (part2)

    FUNDAMENTALS OF DATABASE (part2)

    33問 • 1年前
    iam noone

    DEPTALS (COMP PROG)

    DEPTALS (COMP PROG)

    iam noone · 49問 · 1年前

    DEPTALS (COMP PROG)

    DEPTALS (COMP PROG)

    49問 • 1年前
    iam noone

    HCI HISTORY

    HCI HISTORY

    iam noone · 18問 · 11ヶ月前

    HCI HISTORY

    HCI HISTORY

    18問 • 11ヶ月前
    iam noone

    Module 1 (System Analysis)

    Module 1 (System Analysis)

    iam noone · 18問 · 12ヶ月前

    Module 1 (System Analysis)

    Module 1 (System Analysis)

    18問 • 12ヶ月前
    iam noone

    Module 1 (Data Analytics)

    Module 1 (Data Analytics)

    iam noone · 35問 · 12ヶ月前

    Module 1 (Data Analytics)

    Module 1 (Data Analytics)

    35問 • 12ヶ月前
    iam noone

    Module 2(Data Analytics)

    Module 2(Data Analytics)

    iam noone · 35問 · 11ヶ月前

    Module 2(Data Analytics)

    Module 2(Data Analytics)

    35問 • 11ヶ月前
    iam noone

    Module 1 (Networking)

    Module 1 (Networking)

    iam noone · 25問 · 12ヶ月前

    Module 1 (Networking)

    Module 1 (Networking)

    25問 • 12ヶ月前
    iam noone

    Module 1 (Info Assurance)

    Module 1 (Info Assurance)

    iam noone · 22問 · 12ヶ月前

    Module 1 (Info Assurance)

    Module 1 (Info Assurance)

    22問 • 12ヶ月前
    iam noone

    mod 1 IT LIVING

    mod 1 IT LIVING

    iam noone · 61問 · 11ヶ月前

    mod 1 IT LIVING

    mod 1 IT LIVING

    61問 • 11ヶ月前
    iam noone

    問題一覧

  • 1

    In mapping a unary relation, it is required to have another relation and the identitter of the superior entity will be taken as Foreign key.

    False

  • 2

    In mapping associative entities, the default primary key for the association relation is composed of the primary keys of the two

    true

  • 3

    In mapping binary relations, primary key on the mandatory side becomes the foreign key on optional side when it is____

    1.1

  • 4

    In mapping relations, you need to consider its cardinality.

    true

  • 5

    In transforming ERD to relations, use the simple component attributes for composite attributes

    true

  • 6

    In transforming ERD to relations, if there is a multivalued attribute,another relation will be created and the identifier of the superior entity will be also its identher.

    false

  • 7

    In ER diagram, there are three business rules for every relationship.

    false

  • 8

    Identifier can ba a combination of attributes that can distinguish each occurrence of an endly.

    true

  • 9

    in mapping binary relations. you need to create a new relation with the primary keys of the two entities as primary key when it is ____

    M:M

  • 10

    In mapping binary relations, the Primary key on the one side becomes the foreign key on the many side when it is

    1:M

  • 11

    This symbol used to indicate that the attribute is multivalued?

    []

  • 12

    A person's name, birthday, and social security number are all examples of:

    attributes

  • 13

    The total quiz points for a student for an entire semester is a(n)______ attribute

    derived

  • 14

    A business rule is a statement that defines or constrains some aspect of the business.

    true

  • 15

    Which of the following is NOT a characteristic of a good business rule?

    inconsistent

  • 16

    In an E-R diagram, an associative entity is represented by a rounded rectangle.

    true

  • 17

    A business rule is a statement that defines or constrains some aspect of the business

    True

  • 18

    An entity type whose existence depends on another entity type is called a ______entity

    Weak

  • 19

    An attribute that must have a value for every entity (or relationship) instance is a(n):

    required attribute

  • 20

    An entity type name should be all of the following EXCEPT:

    as short as possible

  • 21

    The common types of entities are:

    all of the choices

  • 22

    An attribute that can be broken down into smaller parts is called a(n)_______attribute.

    composite

  • 23

    Data names should always relate to business characteristics

    true

  • 24

    Data, rather than processes, are the most complex aspects of many modern information systems.

    true

  • 25

    A business rule should be internally consistent.

    true