Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875460
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 11, Problem 18CRP
Program Plan Intro
Closed-world assumption:
It is used for knowledge representation and it is a presumption that statement which is true is also known to be true.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company.
Draw an ER diagram that captures this information.
The database interface of a library allows searching only for a single attribute (such as Title or Author ) in each query. Your friend decided to extend it’s functionality and wrote an algorithm that allows searching for books that satisfy multiple predicates over single attributes in conjunction. He tells you the algorithm reuses the already implemented query functionality and works by intersecting the results ( book id’s ) of queries over single attributes.Which of the following assumptions on your friend’s algorithm are plausible?a) Its worst-case run-time necessarily increases exponentially with respect to the number of attributes in the query.b) Its worst-case run-time depends on the length of the longest result of the single-attribute queries.c) It might be implemented using an join.d) It might be implemented using sorting.
Read the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…
Chapter 11 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Ch. 11.1 - Prob. 1QECh. 11.1 - Prob. 2QECh. 11.1 - Prob. 3QECh. 11.1 - Prob. 4QECh. 11.1 - Prob. 5QECh. 11.2 - Prob. 1QECh. 11.2 - Prob. 2QECh. 11.2 - Prob. 3QECh. 11.2 - Prob. 4QECh. 11.2 - Identify the ambiguities involved in translating...
Ch. 11.2 - Prob. 6QECh. 11.2 - Prob. 7QECh. 11.3 - Prob. 1QECh. 11.3 - Prob. 2QECh. 11.3 - Prob. 3QECh. 11.3 - Prob. 4QECh. 11.3 - Prob. 5QECh. 11.3 - Prob. 6QECh. 11.3 - Prob. 7QECh. 11.3 - Prob. 8QECh. 11.3 - Prob. 9QECh. 11.4 - Prob. 1QECh. 11.4 - Prob. 2QECh. 11.4 - Prob. 3QECh. 11.4 - Prob. 4QECh. 11.4 - Prob. 5QECh. 11.5 - Prob. 1QECh. 11.5 - Prob. 2QECh. 11.5 - Prob. 3QECh. 11.6 - Prob. 1QECh. 11.6 - Prob. 2QECh. 11.6 - Prob. 3QECh. 11.7 - Prob. 1QECh. 11.7 - Prob. 2QECh. 11.7 - Prob. 3QECh. 11 - Prob. 1CRPCh. 11 - Prob. 2CRPCh. 11 - Identify each of the following responses as being...Ch. 11 - Prob. 4CRPCh. 11 - Prob. 5CRPCh. 11 - Prob. 6CRPCh. 11 - Which of the following activities do you expect to...Ch. 11 - Prob. 8CRPCh. 11 - Prob. 9CRPCh. 11 - Prob. 10CRPCh. 11 - Prob. 11CRPCh. 11 - Prob. 12CRPCh. 11 - Prob. 13CRPCh. 11 - Prob. 14CRPCh. 11 - Prob. 15CRPCh. 11 - Prob. 16CRPCh. 11 - Prob. 17CRPCh. 11 - Prob. 18CRPCh. 11 - Give an example in which the closed-world...Ch. 11 - Prob. 20CRPCh. 11 - Prob. 21CRPCh. 11 - Prob. 22CRPCh. 11 - Prob. 23CRPCh. 11 - Prob. 24CRPCh. 11 - Prob. 25CRPCh. 11 - Prob. 26CRPCh. 11 - Prob. 27CRPCh. 11 - Prob. 28CRPCh. 11 - Prob. 29CRPCh. 11 - Prob. 30CRPCh. 11 - Prob. 31CRPCh. 11 - Prob. 32CRPCh. 11 - Prob. 33CRPCh. 11 - What heuristic do you use when searching for a...Ch. 11 - Prob. 35CRPCh. 11 - Prob. 36CRPCh. 11 - Prob. 37CRPCh. 11 - Prob. 38CRPCh. 11 - Suppose your job is to supervise the loading of...Ch. 11 - Prob. 40CRPCh. 11 - Prob. 41CRPCh. 11 - Prob. 42CRPCh. 11 - Prob. 43CRPCh. 11 - Prob. 44CRPCh. 11 - Prob. 45CRPCh. 11 - Draw a diagram similar to Figure 11.5 representing...Ch. 11 - Prob. 47CRPCh. 11 - Prob. 48CRPCh. 11 - Prob. 49CRPCh. 11 - Prob. 50CRPCh. 11 - Prob. 51CRPCh. 11 - Prob. 52CRPCh. 11 - Prob. 53CRPCh. 11 - Prob. 54CRPCh. 11 - Prob. 1SICh. 11 - Prob. 2SICh. 11 - Prob. 3SICh. 11 - Prob. 4SICh. 11 - Prob. 5SICh. 11 - Prob. 6SICh. 11 - Prob. 7SICh. 11 - Prob. 8SICh. 11 - Prob. 9SICh. 11 - Prob. 10SICh. 11 - Prob. 11SICh. 11 - Prob. 12SICh. 11 - A GPS in an automobile provides a friendly voice...Ch. 11 - Prob. 14SI
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
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardRead the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…arrow_forwardWrite down if the following sentences are true or false. a. A database system includes both DBMS software and the data.b. A multi-valued attribute is composed of several components where the composition mayform a hierarchy.c. A key attribute may be composite.d. A recursive relationship is when two different entity types participate in a relationship indistinct roles.e. Generalization is the process of defining a set of subclasses of a superclass.f. If a specialization is overlapping, then the same entity may be a member of more than onesubclass of the specialization.g. If a specialization is total, then an entity of the superclass may not belong to any of thesubclasses.arrow_forward
- Read the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…arrow_forwardConsider the situation when two students are interested in enrolling in the same class but there is only space for one additional. Why can't they both just get the final seat in the car if there's a database system blocking it?arrow_forwardConsider a database that includes four relations Student, Staff, Program, Advisor Student BannerID FName LName PCode 8003778543 James Oloye PO01 8765990453 Paul Carter P002 8002786543 Anita Boris PO01 8307563321 Jane Eyre P001 Staff BannerID FName LName PCode 8014768954 Chimamanda Adichie PO02 8001876565 Paulette Davis P001 Program PCode PName PO01 Library Science PO02 Management and Information Sciencearrow_forward
- To illustrate, imagine you have a database containing the x, y locations and names of several eateries. We shall pretend that just the following kinds of inquiries are made: Whether or if a restaurant can be located at a certain address is the focus of the inquiry. Which indexing system is preferable: B-tree or R-tree? Why?arrow_forwardSuppose you are a judge trying to decide a dispute between a buyer and a supplier. The buyer claims not to have produced a particular email purchase order, while the supplier shows you the purchase order, and certificates and CRLs (Certificate Revocation Lists), demonstrating that the purchase order was signed by the buyer. All documents have been signed by a notary. How would the dates on the various pieces of evidence influence your decision? What if only the purchase order was signed by the notary?arrow_forwardIntegrate any programming language to mySQL with the implementation of Database Normalization and Creation of ER Model. What should I expect? 1. User login interface 2. An interface where I can input my details. (User registration form, Freshman Application Form, Credit Card Application Form, Bank Account Opening Form, and etc.) These are just samples, you can think of your own, of course. 3. From one whole big interface of registration form or any above-mentioned items, I should see the database normalization implemented from whole big table (1NF) to 3NF. The expectation is that the database should have 1NF table and lastly the 3NF tables.arrow_forward
- Consider a situation where there is one open seat in a class with two enrolled pupils. Why can't both students in a database system be assigned to the last seat that is open?arrow_forwardYou have been assign to design a database for Apartment Rental Management System. That is the information you received: Everything starts with an offer of apartments for rent. It is therefore necessary to identify all the buildings held by the company, as well as all the apartments within each of these buildings. We distinguish the building by its address and each of the apartments by its apartment number in the building. When a tenant is accepted, a lease is signed (only one tenant can sign the lease), which determines the amount of the monthly rent, as well as the start and end date of the tenancy. When advertising the apartments, the rent requested is also indicated. The tenants choose an apartment according to the number of rooms and according to the services included, which can be the same from one apartment to another. In order to satisfy the banker, the value of the buildings and their year of construction are preserved, making it possible to compare the rents demanded with the…arrow_forwardSuppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the…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 LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage