What is the difference between a database and a database management system quizlet?
Show
Terms in this set (70)What is a Database? Collection of organized data Storing Data in Databases Data must be stored and organized systematically Three important concepts: Data Hierarchy Data organization in ascending order: Record Structures Data fields in each record of a database table Database Keys Primary Key: Foreign Keys: REA model Resources Events Agents Cardinality Relationships Cardinalities Notations Purpose Database Management Systems Overview Functions Examples NOT SQL (Structured Query Language) Creating Database Tables - Defining Record Format Field Name - Required Data Type - Required Description - Optional Identifying
a Primary Key Creating Relationships Purpose Tools for Data Validation Drop-Down Lists Validation Rules Referential Integrity An example of a validation rule is: An input value must be between 0 and 40 Data Manipulation Languages Schema Subschema Creating Select Queries Queries Dynaset Action Queries Make-table queries NOT find missing data query Sort rewrites the records on disk Indexing sorts on a key but does NOT rewrite the records on disk Online Analytical Processing (OLAP) Complex, multidimensional data analysis Data Mining Utilize a set of data analysis and statistical tools Cloud Databases Form of Internet-based Computing Database-As-A-Service (DAAS) Outsourcing of databases Data Warehouses Pools of data from separate applications Characteristics SQL is an example of: A query language An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems. True Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data. False The basic unit of information in an accounting information database is a table. False A last name such as "Smith" is an example of a useful primary record key. False A Social Security number is a good example of a useful primary record key. True A foreign key is a data field in the records of one file that references a primary key in the records of another file. True All of these are database structures except: C. Star The REA accounting framework is most closely
associated with which of the following? b. An enterprise-wide view of accounting processes Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.
All of these would be likely data fields in a customer order table except: a. Customer name Within a database context, the relationship between "students" and "classes" would most likely d. Many-to-many Within a database context, the relationship between "sales invoice" and "line item" would most likely be: b. One-to-many The process of data normalization refers to: d. none of these Microsoft Access is an example of a database, not a database management system. False Microsoft Access uses a key symbol to identify the primary record key in a database table. True When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems. False An example of an input mask for an Access data field is "000\-00\-0000." True Database management systems allow their users to create "input masks" which help to prevent input errors. True It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others. False Which one of these is not a good guideline to follow when creating tables in a relational database? d. Assign at least 50 characters to each text field A database management system is: b. A set of one or more computer programs A disadvantage of database management systems is that: d. They
are often machine dependent (e.g., not all DBMSs can run on all types of An advantage of using a drop-down box in an Access database is that: a. It helps users avoid input errors
An advantage of using a drop-down box in an Access database is that: a. It helps users avoid input errors At the time that a user starts to input data into a database, an "input mask" for a telephone number in an Access
database might look like: c. (___) ___-____ This tool enables a DBMS to extract only a subset of records from a database: b. Query Which one of these does not characterize a typical
database? D. simple system The part of a data hierarchy B. Record Which of these would NOT be a good primary key for a
file of employee records: B. Last Name In the REA model the "A" stands for: A. Agents in the REA model, which of these would not be
classified as an event? D. date of office picnic Which of these is NOT cardinality between two database entities: B.none-to-none what is the typical cardinality
between a customer and a purchase event: C. one-to- many An insert anomaly occurs when a database user cannot: D. add new data to link the records in a many-to-many relationship within a relational database: A. you must create and intermediate relationship table B. you must create a new database table C. you must use foregin keys and a spread sheet system D. You cannot link records together under these circumstances A. you must create and intermediate relationship table Within the context of databases the term "concurrency" refers to the possibility that: A. a customer of one store might also be a customer of another store. B. two database users might want to access the same record at the same time. C. a credit entry for a customer requires a debit entry for a matching account. D. NONE OF THE ABOVE B. two database users might want to access the same record at the same time. A database is in third normal form (3NF) if it is second normal form and: A. all the data attributes in a record are well defined B. all data attributes in a record depend upon the record key C. the data contains no transitive dependencies D. the data can be stored in two or more separate areas C. the data contains no transitive dependencies What Types of data can be stored in modern databases: C. texts, graphics, video files, audio files, and programming codes The differences between (1) a database management system (DBMS) and (2) a database, is: A. nothing- these terms are synonyms B. the first is hardware, the second is software C. the first is programing software, the second is proprietary data and related files D. the first refers to a complete accounting system, the second refers to a subset of that C. the first is programing software, the second is proprietary data and related files an example of a validation rule is: B. an input value must also have a default value C. and input value must be between 0 and 40 D. you cannot delete parent records that have child records associated with them C. and input value must be between 0 and 40 to construct a select query in microsoft access in which you want to satisfy two conditions simultaneously that is, implemnt and operation you should? A. specify both criteria in separate fields of the criteria line of the query B. Specify both criteria in the same field of criteria line of the query C. specify each criteria in separate fields and in separate criteria lines of the query D. give up; this is not possible in Microsoft Access A. specify both criteria in separate fields of the criteria line of the query To adjust the minimum wage of all payroll employees to the current federal level, you should use an: A. update query to identify all those employees receiving payroll checks but who have no matching record in a payroll master file, you should use a: A.auditor B.Find unmatched records query All of the following are
examples of DBMS except: D. SQL all the following are examples of action queries. D. find missing data query the difference between (1) using an update query and (2) update a single record
is: B. the first updates all secreted records, the second only affected one record C. the first updates more than one table the second updates only one record D. none of these is correct B. the first updates all secreted records, the second only affected one record which one of these data base tools is a account manager most likely to use to preform
online, dill down analyses? B.OLAP SQL is a example of: B. a database management system C. a query language D. a multimedia language C. a query language Students also viewedAIS access25 terms sn306683 AIS final quiz questions.50 terms dylan_armour Chapter 07 Multiple Choice60 terms yamimizu832 Chapter 07 True/ False52 terms yamimizu832 Other sets by this creatorACC 40059 terms kyle_wonski ACC 320 Exam 333 terms kyle_wonski Acc320 Exam 226 terms kyle_wonski Acc312 Exam 145 terms kyle_wonski Verified questionscomputer science What system calls have to be executed by a command interpreter or shell in order to start a new process? Verified answer
computer science Write pseudocode for HASH-DELETE as outlined in the text, and modify HASH-INSERT to handle the special value DELETED. Verified answer
computer science What socket type should be used to implement an intercomputer file-transfer program? What type should be used for a program that periodically tests to see whether another computer is up on the network? Explain your answer. Verified answer
computer science Write a function that accepts a string as an argument and returns true if the argument ends with the substring '.com'. Otherwise, the function should return false. Verified answer Recommended textbook solutions Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions
Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions
Starting Out with C++ from Control Structures to Objects8th EditionGodfrey Muganda, Judy Walters, Tony Gaddis 1,294 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Other Quizlet setsBIO U4 Ecosystems. Stability and Change…36 terms klstomiTEACHER Astronomy Exam 137 terms francieclemson1PLUS computed radiography55 terms shawnagrocott Oklahoma property and casualty key numbers to know32 terms louise5411 What is the difference between database and database management system?A database is a collection of connected information about people, locations, or things. A database management system (DBMS) is a collection of programs that allow you to create, manage, and operate a database.
How is a database different from a database management system quizlet?A database is a collection of related, logically coherent, data used by the application programs in an organization. A database management system (DBMS) defines, creates, and maintains a database. The DBMS also allows controlled access to data in the database.
What is a database management system DBMS quizlet?a set of programs to store and retrieve data. DBMS. (Database Management System) A collection of inter-related data that contains programs to store & access that data in an easy and effective manner.
What is the difference between a database and an information system?Information systems use data stored in computer databases to provide needed information. A database is an organized collection of interrelated data reflecting a major aspect of a firm's activities. 1. Information systems capture data from the organization (internal data) and its environment (external data).
|
