Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 2, Problem 10P
(a)
Explanation of Solution
Tables:
The three tables that are created to describe the relationship between PAINTER, PAINTING, and GALLERY are shown below.
Table Name : “PAINTER”
The following are the components of “PAINTER” table,
PAINTER NUM | PAINTER FNAME | PAINTER LNAME | PAINTER INITIAL |
10014 | Artiste | Josephine | P |
10015 | Itero | Julio | G |
10016 | McDonald | Theresa |
Table Name: “PAINTING”
The following are the components of “PAINTING” table,
PAINTING NUM | PAINTING TITLE | PAINTER NUM | GALLERY NUMBER |
20018 | Dawn Thunder | 10016 | 18 |
20023 | Vanilla Roses | 10015 | 18 |
20041 | Tired Flounders | 10016 | 23 | ...
(b)
Explanation of Solution
Relationship between tables:
The relationship between these tables can be described by using a Crow’s Foot ERD.
Crow’s Foot ERD:
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
3- United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database
to track painters, paintings, and galleries. A painting is created by a particular artist and then
exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be
exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter
can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational
database:
a. What tables would you create, and what would the table components be?
b. How might the (independent) tables be related to one another?
C.
Create a basic ERD.
d. Convert the ERD above to a UML Class Diagram.
United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting is exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is painted by a single painter, but each painter can paint many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database:
a.What tables would you create, and what would the table components be?
b.How might the (independent) tables be related to one another?
2. Using the ERD from Problem 1, create the relational schema. (Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)
To access a database, we need to open a connection to it first and close it once our job is done. Connecting to a database depends on the type of the target database and the database management system (DBMS). For example, connecting to a SQL Server database is different from connecting to an Oracle database. But both these connections have a few things in common: •They have a connection string •They can be opened•They can be closed•They may have a timeout attribute (so if the connection could not be opened within the timeout, an exception will be thrown).Your job is to represent these commonalities in a base class called DbConnection. This class should have two properties: ConnectionString : stringTimeout : TimeSpanA DbConnection will not be in a valid state if it doesn’t have a connection string. So you need to pass a connection string in the constructor of this class. Also, take into account the scenarios where null or an empty string is sent as the connection string. Make sure to…
Chapter 2 Solutions
Database Systems: Design, Implementation, & Management
Ch. 2 - Prob. 1RQCh. 2 - What is a business rule, and what is its purpose...Ch. 2 - How do you translate business rules into data...Ch. 2 - Prob. 4RQCh. 2 - Explain how the entity relationship (ER) model...Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Prob. 4PCh. 2 - Prob. 5PCh. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Prob. 7PCh. 2 - Prob. 8PCh. 2 - Typically, a hospital patient receives medications...Ch. 2 - Prob. 10PCh. 2 - Prob. 11PCh. 2 - Prob. 12PCh. 2 - Prob. 13PCh. 2 - Prob. 14PCh. 2 - Prob. 15PCh. 2 - Prob. 16PCh. 2 - Prob. 17P
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
- PrimeVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. PrimeVideo can own several copies (VIDEO) of each movie (MOVIE). For example, a kiosk may have 10 copies of the movie Twist in the Wind. In the database, Twist in the Wind would be one MOVIE, and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime; therefore, there is an M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in the figure. Write the SQL code to create the table structures for the entities shown in the figure. The structures should contain the attributes specified in the ERD. Use data types (and lengths, if applicable) that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Make…arrow_forwardA trucking company has trucks and drivers and wants to build a database to track truck activity. Each truck is identified by a VIN (Vehicle ID Number) which is 10 characters long. The database also stores the make, model and year of the truck. Drivers are identified by SSN (Social Security Number) which is 9 characters long. The database also stores first name, last name and address of each driver. Trips are also stored in the database. Each trip has one truck making the trip, one driver, date of trip, and total miles covered. Any driver can be assigned to any truck. Write the tables and attributes you would need to have in your database to track this information. Draw the tables and attributes using the format, underlining the primary key (or otherwise showing what the primary key is): TABLENAME1(FIELD1, FIELD2, .. ,FIELDN) TABLENAME2(FIELD1, FIELD2, .. ,FIELDN)arrow_forwardconsider a Scenario: A client wants a database for Order entry at his Shop, database contain information about customers, items, and orders. The following information is to be included. For each customer: (Customer number (unique), Valid shipping/delivery addresses (several per customer), Balance, Credit limit, Discount) - For each order: (customer number, ship-to/delivery address, date of order. Detail lines (several per order), each giving item number, quantity ordered - For each item: Item number (unique), Quantity on hand at each warehouse Item description Design a ER-Diagram (on paper or in MS word) from this above mentioned data. ERD must contain relation degree/constraints.arrow_forward
- ITD 256 Case Study 1 United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Multiple auctions may take place at one gallery. Use draw.io to create your ERD. Relationships and tables are the only requirement for this case study.arrow_forwardJoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover…arrow_forwardImagine you’re planning to estimate the price of the average book at your college bookstore. The bookstore carries 13,000 titles, but you plan to sample only 200 books. You will select a sample of 200 books, record the price of each book, and use the average of the 200 books to estimate the average price of the 13,000 titles in the bookstore. Assume that the bookstore can give you access to a database that lists all 13,000 titles that it carries. 1. How would you collect a cluster sample from the scenario above? 2. How would you collect a simple random sample of books? 3. Discuss one possible way that you could end up with a biased sample when conducting this study (hint: be sure to discuss how the sample could be gathered and the type of bias that could occur).arrow_forward
- 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 of 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.QuestionDraw an E-R diagram for the system according to the above description.arrow_forwardImagine you’re planning to estimate the price of the average book at your college bookstore. The bookstore carries 13,000 titles, but you plan to sample only 200 books. You will select a sample of 200 books, record the price of each book, and use the average of the 200 books to estimate the average price of the 13,000 titles in the bookstore. Assume that the bookstore can give you access to a database that lists all 13,000 titles that it carries. Based on this information, answer the following questions, thank you so much!! :)) 1. What is the sample in this study, and what is the population of interest? 2. How might you collect a simple random sample of books? 3. Choose one of the following options and discuss how you would collect that type of sample (systematic random sample, cluster sample, multistage sample, or quota sample). 4. Discuss one possible way that you could end up with a biased sample when conducting this study (hint: be sure to discuss how the sample could be…arrow_forwardUse the below description of a Car Club System (CCS) to answer the following questions. A Car Club Company (CCC) provides information to their customers about the nearest rental car companies with the available cars. The company intends to build a computerized system called Car Club System CCS). The system allows any member of the public, registered members, and CCC staff to browse a list of car rental companies online. Any member of the public can register to become members of CCS. Registered members and staff of CCC have to login in order to make bookings, cancel bookings, and update their details. Who are the stockholders in Car Club System? What does a use case diagram show? Draw a use case diagram of the Car Club System.arrow_forward
- A library service wants to create a database to store details ofits libraries, books and borrowers. Details include the following: A book has a unique ISBN number, a title and one or more authors. The library service may own several copies of a given book, each of which is located in one of the service's libraries. A given library contains many books, and in order to distinguish different copies of the same book a library assigns a different copy- number to each of its copies of a given book; the price that was paid for each copy is also recorded. Every library has a unique name and is either a main library or a branch library. A main library may have zero or more branch libraries and every branch library is a branch ofexactly one main library, A borrower has a name and a unique ID code. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, butit is assumed that each such loan…arrow_forwardImagine a database of students where the StudentID is the main key, and there are other indexes on Major, Age, Marital Status, and HomeZipCode (all secondary keys). Let's assume the institution wanted a list of MIS or computer science majors who were over 25 and married and were from the 45462 postcode code OR computer engineering majors who were single and were from the 45462 zip code. In any case, they wanted the list to come from the 45462 zip code. How can indexes be used to guarantee that individuals will only have access to the info that fulfills this prerequisite?arrow_forwardDescribe the concept of "lazy loading" in the context of database connectivity.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education