18 Questions
A software system that is used to create, maintain, and provide controlled access to user databases is called a Database Management System (____)
DBMS
Disadvantages of File Processing include problems with data dependency and duplicate data, as well as problems with data (____)
redundancy
The Database Approach requires a Database Management System (____)
DBMS
One customer may place many orders, but each order is placed by a single (____)
customer
One order has many order lines; each order line is associated with a single (____)
order
One product can be in many order lines, each order line refers to a single (____)
product
Many-to-many relationship involves __________ products and orders
many
The purpose of Systems Development Life Cycle is to provide a _________ understanding
preliminary
Systems Development Life Cycle includes steps like Planning, Analysis, Logical Design, Physical Design, __________, and Maintenance
Implementation
In Systems Development Life Cycle, the Deliverable for Planning phase is a request for _________
study
Database activity in Systems Development Life Cycle involves enterprise modeling and early conceptual data _________
modeling
The purpose of Systems Development Life Cycle in the final phase is to develop technology and organizational _________
specifications
Database processing programs are part of database ______
implementation
Systems Development Life Cycle includes purpose like programming, testing, training, installation, and ______
documenting
Database maintenance involves activities like monitoring, repairing, and ______
enhancing
The three-schema architecture includes external schema, internal schema, and ______
database schema
Prototyping is part of Database ______
Methodology
Enterprise Database Applications may follow a three-tiered client/server database ______
architecture
This quiz covers the objectives, definitions, graphical displays, data properties, disadvantages of file processing, and problems with data dependency in the context of databases. It aims to test your understanding of data types, field sizes, allowable values, data context, and their significance in decision making.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free