CS403 Quiz No.1 Shared by Khaliq (Solved)

A table can be logically connected to another table by defining a __.

hyperlink
common attribute
primary key
 superkey

Which of the following is INCORRECT statement concerning the database design process?

During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

  

Which of the following is correct regarding Dataflow diagram?

Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities

A collection of concepts that can be used to describe the structure of a database
Database
DBMS
Data model
Data

Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:
Database Designer
Database Administrator
End User
Application Programmer

A software package designed to store and manage databases
Select correct option:
Database
DBMS
Data model
Data

The main software package that supports a database management approach is called
Select correct option:
Data Dictionary
Report Generator
Database Management System
Distributed database

A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
Select correct option:
True
False
Partially True
None of the given

Which of the following is NOT a component of a DFD?
Select correct option:
Dataflow
Datastore
External entities
Relationship between external entities

A________is used to maintain a connection between the users of the database system.
Select correct option:
mail server
file server
client-server
none of the given