DAT604 Database Design and Implementation

Card Set Information

Author:
caldreaming
ID:
275572
Filename:
DAT604 Database Design and Implementation
Updated:
2014-05-28 21:13:12
Tags:
database design
Folders:

Description:
Database Design and Implementation
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user caldreaming on FreezingBlue Flashcards. What would you like to do?


  1. DBMS is the shielding between physical data types and its users.
    True
  2. The ER Model is a conceptual model which has both data types and data values.
    False
  3. A multi-user database system is designed for only one user at a time.
    False
  4. A database is a set of relations  and a relation is a set of tuples.
    True
  5. In a relational database both character string and numerical data can be stored for real business applications.
    True
  6. SQL is a 4th generation computer language which has two parts: 1)DDL and 2) DML and all RDBMS use these for database creation and data processing purposes.
    True
  7. A data dictionary is a database of data descriptions which can be created by using the DML part of SQL.
    False
  8. In a network data model one child can have only one parent, but one parent can have my children.
    False
  9. Relational database model was first proposed by an employee from the Oracle Company.
    False
  10. A derived attribute is a virtual attribute which does not exist in the database, but it can be derived from some other attributes that exist in the database.
    True
  11. A null value can mean: 

    A) the value of the attribute is zero  
    B) the value of the attribute is unknown  
    C) the attribute has a formula type
    D) the user has deleted an entity tuple from the relation  
    B) the value of the attribute is unknown
    (this multiple choice question has been scrambled)
  12. The description of data types and structures of a database is called;

    A) user data  
    B) application data
    C) raw data  
    D) transaction data  
    E) metadata  
    E) metadata
    (this multiple choice question has been scrambled)
  13. An attribute has:

    1) a value  
    2) a type  
    3) both 1 & 2  
    4) none
    3) both 1 & 2
  14. A relation must observe the following;

    A) each tuple contain exactly one value              
    B)order of attributes is not important              
    C) order of tuples is not important  
    D) all of the above  
    E) none
    D) all of the above
  15. A relation follows;

    A) set theory  
    B) relational theory  
    C) both a and b  
    D) none
    C) both a and b
    (this multiple choice question has been scrambled)
  16. A relation;

    A) has columns  
    B) has rows  
    C) should contain data  
    C) has a name  
    D) all of the above
    D) all of the above
  17. The set of values that a column can have is called the ___________. 

    A) relation
    B) schema  
    C) business rules  
    D) domain  
    D) domain
    (this multiple choice question has been scrambled)
  18. Which of the following is not a key element of E-R models? 

    A) entity            
    B) attribute
    C) relationship              
    D) data  
    D) data
    (this multiple choice question has been scrambled)

What would you like to do?

Home > Flashcards > Print Preview