Entity Relationship Data Model - 1
Entity Relationship Data Model - 1
Questions
Which of the following represents a software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens?
- Data dictionary
- Database management system (DBMS)
- Decision support system
- Relational database
The separation of the data definition from the program is known as
- Data dictionary
- Data independence
- Data integrity
- Referential integrity
In the client/server model, the database
- is downloaded to the client upon request
- is shared by both the client and server
- resides on the client side
- resides on the server side
What type of ‘database’ system is represented by the traditional storage of data that is organised by a customer, stored in separate folders in filing cabinets?
- Hierarchical
- Network
- Object oriented
- Relational
The database design that consists of multiple tables, that are linked together through matching data stored in each table is called a
- hierarchical database
- network database
- object oriented database
- relational database
What is the main limitation of hierarchical databases?
- Limited capacity (unable to hold much data)
- Limited flexibility in accessing data
- Overhead associated with maintaining indexes
- The performance of the database is poor
An abstract data type is used to
- link data from remote databases
- prevent users from getting to database security information
- provide a conceptual view of the data so it is easier to understand
- store complex data structure to represent the properties of objects
Which component of the database management system (DBMS) most affects the ability to handle large problems (scalability)?
- Data Storage Subsystem
- Database Engine
- Query Processor
- Security Subsystem
The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is
- OODB incorporates methods in with the definition of the data structure, while RDB does not
- OODB supports multiple objects in the same database while RDB only supports a single table per database
- RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships to be defined between objects
- RDB supports indexes, while OODB does not support indexes
Which of the following items is not the advantage of a DBMS?
- Improved ability to enforce standards
- Improved data consistency
- Local control over the data
- Minimal data redundancy
When building a database, the data dealing with an entity is modelled as a
- attribute
- class
- object
- table
Which of the following diagrams are used by database system modelers to graphically represent both the data structure and how the different objects are interrelated?
- Class Diagram
- Data Diagram
- Object Diagram
- Table Relationship Diagram
In relational database model, after conceptually designing your database, the information contained in a single class would be stored in a
- database
- field
- property
- table
The property (or set of properties) that uniquely defines each row in a table is called the
- identifier
- index
- primary key
- symmetric key
Business rules can be represented in the database through
- associations (or relationships)
- attributes
- properties
- secondary keys