GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

WEEK 3 APT 1050

Denis Ndungu 12 questions

Take the quiz

This quiz has question types that open in the usual player.

Questions in this quiz (12)

  1. 1Define database design?
    its the [blank_start]organization[blank_end] of data [blank_start]according to[blank_end] a database [blank_start]model[blank_end]
    1. Aorganization
    2. Baccording to
    3. Cmodel
  2. 2what is data modeling?
    Data modeling is the process of [blank_start]documenting[blank_end] a complex [blank_start]software system[blank_end] design as an easily understood [blank_start]diagram[blank_end], using text and symbols to represent the way data needs to [blank_start]flow[blank_end]
    1. Adocumenting
    2. Bsoftware system
    3. Cdiagram
    4. Dflow
  3. 3what is conceptual database design?
    The process of [blank_start]constructing[blank_end] a [blank_start]model[blank_end] of the data used in an enterprise. [blank_start]independent[blank_end] of all [blank_start]physical[blank_end] considerations.
    1. Aconstructing
    2. Bmodel
    3. Cindependent
    4. Dphysical
  4. 4what is logical database design?
    process of constructing a model of the data used based on a [blank_start]specific data model[blank_end] (e.g. relational), but [blank_start]independent[blank_end] of a [blank_start]particular DBMS[blank_end] product and other physical considerations
    1. Aspecific data model
    2. Bindependent
    3. Cparticular DBMS
  5. 5What is physical database design?
    the process of producing a description of he [blank_start]database[blank_end] [blank_start]implementation[blank_end] on [blank_start]secondary storage[blank_end]
    1. Adatabase
    2. Bimplementation
    3. Csecondary storage
  6. 6What is an entity-relationship model?
    a [blank_start]logical represenation[blank_end] of the data for an organization or for a business area,using [blank_start]entities[blank_end] for categories of data and [blank_start]relationchips[blank_end] for [blank_start]assocciations[blank_end] between entities
    1. Alogical represenation
    2. Bentities
    3. Crelationchips
    4. Dassocciations
  7. 7What is an entity relationship diagram?
    a [blank_start]graphical[blank_end] represenation of an [blank_start]entity-relationship[blank_end] diagram
    1. Agraphical
    2. Bentity-relationship
  8. 8List the threekey elements in E-RD
    [blank_start]Entities[blank_end]: objects or items of interest
    [blank_start]Attributes[blank_end]: facts about or properties of an entity
    [blank_start]Relationships[blank_end]: links between entities
    1. AEntities
    2. BAttributes
    3. Cassociations
    4. DRelationships
  9. 9Define an entity type
    a group of [blank_start]bjects[blank_end] with [blank_start]same properties[blank_end], identified by an enterprise as having an [blank_start]independent existence[blank_end]
    1. Abjects
    2. Bsame properties
    3. Cindependent existence
  10. 10Differentiate the following terms: entity instance and entity type

    [blank_start]Entity instance[blank_end]-person, place, object , event, concept(often corresponds to a row in a table)
    [blank_start]Entity type[blank_end]-collection of entities(often corresponds to a table)
    1. AEntity instance
    2. BEntity type

Information

Description
Modeling Data in the Organization
Language
English
Views
0
Tags
apt 1050quiz
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?