Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4, Problem 4.6RQ
Explanation of Solution
Business rule:
Business rules define the entities, relationships, and attributes that are used in the
- It includes the process, tactics, aspects, and aesthetics of the business.
- It is the statement used to define or limit some business feature. It is planned to declare the business structure or to organize the behavior of business.
- These rules must be understood by user and database designer.
Example of business rule:
The business rule for the “sales” database used to demonstrate how the product is sold out from the website. The scope of the database is buying things from online websites...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Is there a technique that, depending on the circumstances, could have a significant effect on the efficacy of the database that designers should be aware of?
Give an example of a business rule that would need to be documented in a database development project
Draw an ER diagram of the following:
You are going to set up a database company that builds a product for art galleries. The core of this product is a database that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, we need to record its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. An artist may paint many pieces of artwork and a piece of artwork is done by one artist. Pieces of artwork are also classified into groups of various kinds (for example, portraits, works by Picasso, or works of the 19th century). A given piece may belong to more than one group. Each group is identified by a name that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent…
Chapter 4 Solutions
Database Concepts (8th Edition)
Ch. 4 - Prob. 4.1RQCh. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - What is a use case, and what is its purpose?Ch. 4 - Give an example of a data constraint.Ch. 4 - Prob. 4.6RQCh. 4 - Define the term entity, and give an example other...Ch. 4 - Explain the difference between an entity class and...Ch. 4 - Define the term attribute, and give examples for...Ch. 4 - Define the term identifier, and indicate which...
Ch. 4 - Prob. 4.11RQCh. 4 - Prob. 4.12RQCh. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - List and give an example of the three types of...Ch. 4 - Prob. 4.16RQCh. 4 - Prob. 4.17RQCh. 4 - Prob. 4.18RQCh. 4 - Define the term weak entity, and give an example...Ch. 4 - Explain the ambiguity in the definition of the...Ch. 4 - Define the term associative entity, and give an...Ch. 4 - Define the terms supertype, subtype, and...Ch. 4 - What is an exclusive subtype relationship? Give an...Ch. 4 - What is an inclusive subtype relationship? Give an...Ch. 4 - Prob. 4.25RQCh. 4 - Prob. 4.26RQCh. 4 - Prob. 4.27RQCh. 4 - Prob. 4.28RQ
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
- A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.arrow_forwardCreate an ER diagram for the following requirements:You are asked to design a database to store music album information. A simplified set of requirementsare provided below.- A music album has a title, year of release, total running time, one or more artists, and list ofsongs.- Each song has a lead artist and may have a list of additional artists. Each song has a list of otherassociated people such as mixer, mix engineer, keyboards, guitar, etc. Each song has a genre,running time, and lyrics. Each song can be associated with many albums, but needs to beassociated with at least one.- Each person has a first name, last name, and nickname.arrow_forwardKindly go through this. The database development starts with the requirements analysis. There are many sources for gathering requirements. One of the important sources for requirements is “user interview”. During these interviews, users are asked about what kind of a system they need. Then requirements gathered from the interviews are transformed into a data model. Assume that a database designer made an interview and created an E-R diagram as above. Write a scenario that the user described requirements as in the Library Management System case study in Chapter 3.3 of Sharma et al. (2010, p. 77) during the interview - 3.3 A case study involving a Library Management System - This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms:"The system will manage author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The…arrow_forward
- Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.arrow_forwardSpecification Suppose you are asked to design a club database system based on the _following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.arrow_forwardDirect connections between external entities and the database are not permitted. This is one of the data flow diagram design concepts to consider. What does this advice imply?arrow_forward
- Is it possible to write a database design implementation report on "Work Bench"?arrow_forwardQUESTION 2: Design and implement design pattern that can be used to create a counter to provide unique sequential numbers, such as might be required for use as primary keys in a database. Based on the given basic information: • Draw appropriate class diagram? • Implement your class diagram in java?arrow_forwardAre there any fundamental decisions to be made when it comes to physical database design?arrow_forward
- In a hypothetical scenario, you have been entrusted with designing and presenting a training session for new users of your school's database system. What topics do you want to tackle specifically during the session?arrow_forwardDesign and draw an ER diagram that captures the information about the university. Consider thefollowing information about a university database: Professors have an SSN, a name, an age, a rank,and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a startingdate, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degreeprogram (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project’sprincipal investigator). Each project is worked on by one or more professors (known as theproject’s co-investigators). Professors can manage and/or work on multiple projects. Each projectis worked on by one or more graduate students (known as the project’s research assistants). Whengraduate students work on a project, a professor must supervise their work on the project.Graduate students can work on multiple projects, in which case they will have a (potentiallydifferent) supervisor for each one. Departments have a…arrow_forwardDirect connections between external entities and the database are not permitted under any circumstances. It should be kept in mind as one of the data flow diagram design concepts to consider. What do you think the repercussions of this suggestion will be?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 LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning