Question: BUSINESS&COMPUT CSC239-01 Database Systems Test #1 DATABASE SYSTEMS Date: Name: Databasesystems Test#1-Chapters 1.2.3 A. Prom the word bank below, rill in the word in the
BUSINESS&COMPUT CSC239-01 Database Systems Test #1 DATABASE SYSTEMS Date: Name: Databasesystems Test#1-Chapters 1.2.3 A. Prom the word bank below, rill in the word in the left column that best represents the definition on the same row of the table. (2 points each 16 points) Data Base Management System Key Data Data Manipulation Language Data Independence Field Record File Word Phrase Definition Raw facts from which the required information is derived. Have little meaning unless they are grouped in a logical manner Allows us to manipulate the database contents. A character or a group of characters (numeric or alphanumeric) that describes a specif characteristic. May define a telephone number, a date, or other specific characteristi that the end user wants to keep track of A computer program designed to manage a database A collection of related records that contain information of interest to the end user Exists when changes in the data characteristics do not require changes in the program that access those data A logically connected set of one or more fields that describes a person, place, event thing. A unique identifier Diagramming (3 points each 6 points) I. Use the scenario described by "A customer can make many payments, but each payment i made by only one customer" as the basis to draw an entity relationship diagram (ERD containing only the entity names. 2. Draw the Object Oriented Data Model that corresponds to the above scenario
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
