暗記メーカー

暗記メーカー

​

2.2: Relational Model and ER Model

2.2: Relational Model and ER Model
19問 • 2年前
  • ユーザ名非公開
    • 通報

    問題一覧

  • 1

    Which of the following is for “Attributes”, “Tuple” and “Relation schema” 1. Row in relation 2. Column in a relation 3. Logical structure of data base

    Tuple, Attributes, Relation schema

  • 2

    Which of the following best describes a relation in the context of a relational data model?

    A collection of one or more tables

  • 3

    Which stage of database design involves converting the ER model to a relational database scheme?

    Logical database design

  • 4

    Which stage of database design involves analysing the relations to identify potential problems and to refine it using design theory for normalisation?

    Scheme refinement

  • 5

    Choose the correct description of the terminologies, [“Entity” “Instances” “Relationship”], of an entity relationshio model. 1. A snapshot of a set of relationships 2. Connection among two or more entity sets 3. Abstract object of some sort; a thing

    Instances, Relationship, Entity

  • 6

    Which of these is true about the entity relationship model?

    It is a conceptual database design

  • 7

    What shape is used to represent entity set?

    Rectangle

  • 8

    What shape is used to represent attribute?

    Oval

  • 9

    How many attributes are there?

    3

  • 10

    Which is the entity set?

    Employees

  • 11

    What is the shape that represent relationship

    Diamond

  • 12

    How many connection are there with the relationship?

    3

  • 13

    What is a key in an entity-relationship diagram?

    A set of attributes that uniquely identifies an entity

  • 14

    Can the same entity set participate in different relationship sets?

    Yes, an entity set can participate in a different relationship sets

  • 15

    A department is managed by one employee. The same employee can manage multiple departments. How many employees can manage multiple departments in the given scenario?

    Multiple employees can manage multiple departments

  • 16

    A department is managed by one employee. The same employee can manage multiple departments. What is the key constraint on the “Manages” relation in the given scenario?

    Each department can have at most one manager

  • 17

    In a one-to-one relationship, how many entities in A can be associated with an entity in B?

    At most one

  • 18

    What relationship does this ER model show?

    Many-to-many

  • 19

    Why is an ER model subjective?

    Analysing alternatives can be tricky, especially for a large enterprise, There are many ways to model given requirements

    • 1.1: Software life cycle

    1.1: Software life cycle

    ユーザ名非公開 · 17問 · 2年前

    1.1: Software life cycle

    1.1: Software life cycle

    17問 • 2年前
    ユーザ名非公開

    Intro to computing - Lecture 1

    Intro to computing - Lecture 1

    ユーザ名非公開 · 32問 · 2年前

    Intro to computing - Lecture 1

    Intro to computing - Lecture 1

    32問 • 2年前
    ユーザ名非公開

    Chapter 5

    Chapter 5

    ユーザ名非公開 · 7問 · 2年前

    Chapter 5

    Chapter 5

    7問 • 2年前
    ユーザ名非公開

    Intro to Comp - Lecture 4

    Intro to Comp - Lecture 4

    ユーザ名非公開 · 34問 · 2年前

    Intro to Comp - Lecture 4

    Intro to Comp - Lecture 4

    34問 • 2年前
    ユーザ名非公開

    Intro to comp - Lecture 3

    Intro to comp - Lecture 3

    ユーザ名非公開 · 24問 · 2年前

    Intro to comp - Lecture 3

    Intro to comp - Lecture 3

    24問 • 2年前
    ユーザ名非公開

    Intro to Comp - Lecture 2

    Intro to Comp - Lecture 2

    ユーザ名非公開 · 28問 · 2年前

    Intro to Comp - Lecture 2

    Intro to Comp - Lecture 2

    28問 • 2年前
    ユーザ名非公開

    Quiz 2

    Quiz 2

    ユーザ名非公開 · 7問 · 2年前

    Quiz 2

    Quiz 2

    7問 • 2年前
    ユーザ名非公開

    1.2: Software Engineering Methodologies

    1.2: Software Engineering Methodologies

    ユーザ名非公開 · 20問 · 2年前

    1.2: Software Engineering Methodologies

    1.2: Software Engineering Methodologies

    20問 • 2年前
    ユーザ名非公開

    2.3: Converting ER Model to Relational model

    2.3: Converting ER Model to Relational model

    ユーザ名非公開 · 5問 · 2年前

    2.3: Converting ER Model to Relational model

    2.3: Converting ER Model to Relational model

    5問 • 2年前
    ユーザ名非公開

    Quiz 1

    Quiz 1

    ユーザ名非公開 · 8問 · 2年前

    Quiz 1

    Quiz 1

    8問 • 2年前
    ユーザ名非公開

    Week 2 Concurrency

    Week 2 Concurrency

    ユーザ名非公開 · 10問 · 11ヶ月前

    Week 2 Concurrency

    Week 2 Concurrency

    10問 • 11ヶ月前
    ユーザ名非公開

    Week 3 Mutual Exclusion

    Week 3 Mutual Exclusion

    ユーザ名非公開 · 3回閲覧 · 12問 · 11ヶ月前

    Week 3 Mutual Exclusion

    Week 3 Mutual Exclusion

    3回閲覧 • 12問 • 11ヶ月前
    ユーザ名非公開

    Week 4 Synchronisation

    Week 4 Synchronisation

    ユーザ名非公開 · 10問 · 11ヶ月前

    Week 4 Synchronisation

    Week 4 Synchronisation

    10問 • 11ヶ月前
    ユーザ名非公開

    Week 5 Processes and scheduling

    Week 5 Processes and scheduling

    ユーザ名非公開 · 22問 · 11ヶ月前

    Week 5 Processes and scheduling

    Week 5 Processes and scheduling

    22問 • 11ヶ月前
    ユーザ名非公開

    Week 6 Interprocess Communication

    Week 6 Interprocess Communication

    ユーザ名非公開 · 22問 · 11ヶ月前

    Week 6 Interprocess Communication

    Week 6 Interprocess Communication

    22問 • 11ヶ月前
    ユーザ名非公開

    Week 7 File system

    Week 7 File system

    ユーザ名非公開 · 13問 · 11ヶ月前

    Week 7 File system

    Week 7 File system

    13問 • 11ヶ月前
    ユーザ名非公開

    Week 8 Virtual Memory

    Week 8 Virtual Memory

    ユーザ名非公開 · 22問 · 11ヶ月前

    Week 8 Virtual Memory

    Week 8 Virtual Memory

    22問 • 11ヶ月前
    ユーザ名非公開

    Week 9 Architectures

    Week 9 Architectures

    ユーザ名非公開 · 10問 · 11ヶ月前

    Week 9 Architectures

    Week 9 Architectures

    10問 • 11ヶ月前
    ユーザ名非公開

    BigO scenario qns

    BigO scenario qns

    ユーザ名非公開 · 8問 · 9ヶ月前

    BigO scenario qns

    BigO scenario qns

    8問 • 9ヶ月前
    ユーザ名非公開

    問題一覧

  • 1

    Which of the following is for “Attributes”, “Tuple” and “Relation schema” 1. Row in relation 2. Column in a relation 3. Logical structure of data base

    Tuple, Attributes, Relation schema

  • 2

    Which of the following best describes a relation in the context of a relational data model?

    A collection of one or more tables

  • 3

    Which stage of database design involves converting the ER model to a relational database scheme?

    Logical database design

  • 4

    Which stage of database design involves analysing the relations to identify potential problems and to refine it using design theory for normalisation?

    Scheme refinement

  • 5

    Choose the correct description of the terminologies, [“Entity” “Instances” “Relationship”], of an entity relationshio model. 1. A snapshot of a set of relationships 2. Connection among two or more entity sets 3. Abstract object of some sort; a thing

    Instances, Relationship, Entity

  • 6

    Which of these is true about the entity relationship model?

    It is a conceptual database design

  • 7

    What shape is used to represent entity set?

    Rectangle

  • 8

    What shape is used to represent attribute?

    Oval

  • 9

    How many attributes are there?

    3

  • 10

    Which is the entity set?

    Employees

  • 11

    What is the shape that represent relationship

    Diamond

  • 12

    How many connection are there with the relationship?

    3

  • 13

    What is a key in an entity-relationship diagram?

    A set of attributes that uniquely identifies an entity

  • 14

    Can the same entity set participate in different relationship sets?

    Yes, an entity set can participate in a different relationship sets

  • 15

    A department is managed by one employee. The same employee can manage multiple departments. How many employees can manage multiple departments in the given scenario?

    Multiple employees can manage multiple departments

  • 16

    A department is managed by one employee. The same employee can manage multiple departments. What is the key constraint on the “Manages” relation in the given scenario?

    Each department can have at most one manager

  • 17

    In a one-to-one relationship, how many entities in A can be associated with an entity in B?

    At most one

  • 18

    What relationship does this ER model show?

    Many-to-many

  • 19

    Why is an ER model subjective?

    Analysing alternatives can be tricky, especially for a large enterprise, There are many ways to model given requirements