Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN: 9781305657458
Author: Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 11, Problem 1MC
Program Description Answer
A consistency check tests ensures that the two or more fields have logical relationship and the data is represented in the correct format.
Therefore, the correct option is “B”.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
True and falseLogical level is the physical level representation of database true and false mein bataiye
Q : Draw an ERD from the following business rules: Use proper notations for the type of attributes.
A software system is to be developed for an educational institute. The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’s data including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the time of student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators.
Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name).
The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought).
1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…
Chapter 11 Solutions
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
Ch. 11 - Define the terms, database and database software....Ch. 11 - Prob. 2SGCh. 11 - Prob. 3SGCh. 11 - Prob. 4SGCh. 11 - Prob. 5SGCh. 11 - Explain how a DBMS might manage deleted or...Ch. 11 - Prob. 7SGCh. 11 - Prob. 8SGCh. 11 - Prob. 9SGCh. 11 - Prob. 10SG
Ch. 11 - Prob. 11SGCh. 11 - Prob. 12SGCh. 11 - Prob. 13SGCh. 11 - Prob. 14SGCh. 11 - Prob. 15SGCh. 11 - Prob. 16SGCh. 11 - Prob. 17SGCh. 11 - A(n) _____ is a request for specific information...Ch. 11 - Prob. 19SGCh. 11 - Prob. 20SGCh. 11 - Prob. 21SGCh. 11 - Prob. 22SGCh. 11 - Prob. 23SGCh. 11 - Prob. 24SGCh. 11 - Prob. 25SGCh. 11 - Prob. 26SGCh. 11 - Prob. 27SGCh. 11 - Prob. 28SGCh. 11 - Prob. 29SGCh. 11 - Prob. 30SGCh. 11 - Prob. 31SGCh. 11 - Prob. 32SGCh. 11 - Prob. 33SGCh. 11 - Prob. 34SGCh. 11 - Prob. 35SGCh. 11 - Prob. 36SGCh. 11 - Prob. 37SGCh. 11 - Prob. 38SGCh. 11 - Prob. 39SGCh. 11 - Prob. 40SGCh. 11 - Prob. 41SGCh. 11 - Prob. 42SGCh. 11 - Prob. 43SGCh. 11 - Define the following terms: programming language,...Ch. 11 - Prob. 45SGCh. 11 - Define the terms, procedural language, compiler,...Ch. 11 - Prob. 47SGCh. 11 - Prob. 48SGCh. 11 - Prob. 49SGCh. 11 - Prob. 1TFCh. 11 - Prob. 2TFCh. 11 - Prob. 3TFCh. 11 - Prob. 4TFCh. 11 - Prob. 5TFCh. 11 - Prob. 6TFCh. 11 - Prob. 7TFCh. 11 - Prob. 8TFCh. 11 - One way to secure a database is to allow only...Ch. 11 - In a rollforward, the DBMS uses the log to undo...Ch. 11 - Prob. 11TFCh. 11 - Prob. 12TFCh. 11 - Prob. 1MCCh. 11 - Prob. 2MCCh. 11 - Prob. 3MCCh. 11 - Prob. 4MCCh. 11 - Prob. 5MCCh. 11 - Prob. 6MCCh. 11 - _____ feasibility measures whether an organization...Ch. 11 - Prob. 8MCCh. 11 - Prob. 1MCh. 11 - Prob. 2MCh. 11 - Prob. 3MCh. 11 - Prob. 4MCh. 11 - Prob. 5MCh. 11 - Prob. 6MCh. 11 - Prob. 7MCh. 11 - Prob. 8MCh. 11 - Prob. 9MCh. 11 - Prob. 10MCh. 11 - Prob. 2CTCh. 11 - Prob. 3CTCh. 11 - What is function creep?Ch. 11 - Prob. 5CTCh. 11 - Prob. 6CTCh. 11 - Prob. 7CTCh. 11 - Prob. 8CTCh. 11 - Prob. 9CTCh. 11 - Prob. 10CTCh. 11 - Prob. 11CTCh. 11 - Prob. 12CTCh. 11 - Prob. 13CTCh. 11 - Prob. 14CTCh. 11 - Prob. 15CTCh. 11 - Prob. 16CTCh. 11 - Prob. 17CTCh. 11 - Prob. 18CTCh. 11 - Prob. 19CTCh. 11 - Prob. 20CTCh. 11 - Prob. 21CTCh. 11 - Prob. 22CTCh. 11 - Prob. 23CTCh. 11 - Prob. 24CTCh. 11 - Prob. 25CTCh. 11 - Prob. 26CTCh. 11 - Prob. 27CTCh. 11 - Prob. 28CTCh. 11 - Prob. 1PSCh. 11 - Prob. 2PSCh. 11 - Prob. 3PSCh. 11 - Prob. 4PSCh. 11 - Prob. 5PSCh. 11 - Prob. 6PSCh. 11 - Prob. 7PSCh. 11 - Prob. 8PSCh. 11 - Database Recovery Your boss has informed you that...Ch. 11 - Prob. 10PSCh. 11 - Prob. 11PSCh. 11 - Prob. 1.1ECh. 11 - Prob. 1.2ECh. 11 - Prob. 1.3ECh. 11 - Prob. 2.1ECh. 11 - Prob. 2.2ECh. 11 - Prob. 2.3ECh. 11 - Prob. 3.1ECh. 11 - Prob. 3.2ECh. 11 - Prob. 3.3ECh. 11 - Prob. 4.1E
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forward4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table records the date of check-out, patron’s ID, the identifier of the book copy from the BOOK_COPY table, and the due date.arrow_forwardExplain requirement validation.arrow_forward
- NB: don't answer i. answer ii, iii, iv and v respectably only Read the scenario and answer the questions that follow Scenario You have been tasked to design a database for a new bank. The specifications for the database include: customer details include their name, address, phone, and National Identification number. A nationalidentification number is required for each customer for all account types. A customer’s contact address includes street, city and country as well as two phone numbers (cellphone, office line). One customer can own at least one account and every account is identified by its numbers, type and balance. . A customer may own a savings, cheque or loan account. Questionsi. Using an appropriate tool, draw the conceptual diagram for the proposed database. ii. Develop the logical model. iii. Define the physical schema for the proposed database. iv. Write SQL statements to implement the database. v. Populate each of the identified tables with 2 records.arrow_forwardWhen building a data model, why is it sometimes preferable to not include a certain piece of information?arrow_forwardWhich statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_forward
- How do data dictionaries assist in data validation and consistency checks?arrow_forwardCan the security of a field be managed by choosing the data type it stores?arrow_forwardPart A - Database design case study In this part, you need to provide a short description of the application/website for which you will be designing the database (The overview of your own/chosen case study that is related to the assignment topic), outline the basic functions that your database needs to support, identify the data requirements, and business rules.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage