
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question

Transcribed Image Text:B. Art Museum Database
Draw an EER diagram to keep track of information for an art museum. Assume that the
following requirements were collected: (10 marks)
The museum has a collection of art objects. Each art object has a unique ID, a year (when it was
created, if known), a title, and a description. Art objects must be categorized based on their type.
There are three main types: painting, sculpture, plus another type called other to accommodate
objects that do not fall into one of the two main types.
A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas,
wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was
created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type
(print, photo, etc.) And style.
The museum keeps track of artist information, if known: name, date born (if known), date died (if
not living), country of origin, epoch, main style, and description. The name is assumed to be
unique. The art object is created by one artist. An artist may create many art object.
Different exhibitions occur, each having a number, name, start date, and end date. Exhibitions are
related to all the art objects that were on display during the exhibition. An art object may be
displayed in multiple exhibitions.
Information is kept on exhibition visitors which they attend including mobile, name, address and
phone(unique). The date in which visitor register must be kept. A visitor may write a review on
the exhibition he/she attended.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images

Knowledge Booster
Similar questions
- C++ What is relation? Define the properties of a relation.arrow_forwardBreak the list in Figure 1-31 into tables, each with a single theme. Create ID columns as you think necessary.arrow_forwardTask Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table. Through Java application, use SQL to insert (random but meaningful) data records in the above tables:1) Create two different departments (named: Marketing and Human Resources)2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3.3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.arrow_forward
- Part Design a database for an Access Control System. The purpose of the system is to control who has access to which doors at what time. There are six entities in this database: ● ● Users Groups O A user can be assigned to more than one group. Doors AccessRules O Decides which Group has access to which Door at which TimeSchedule. Example: Group A can access the Front Door on Monday from 7am to 9pm. o o Example: Group B can access the Back Door on Saturday from 8am to 10pm. TimeSchedules To make it simple, we only need to pport Weekly Schedules. The TimeSchedules table has the following columns: Id O O DayOfWeek StartTime ■ EndTime o Example: a schedule with DayOfWeek-Monday, StartTime=7:00, EndTime=23:00 means this schedule grants access on Monday from 7am to 11pm. Entrance Logs O This table keeps a permanent record of which user accessed which door at what time. o The logs must remain valid even after the related records have been updated. For example, after user X is deleted, the…arrow_forwardWhat is the reason for not include a data object in a data model?arrow_forwardSUPLIER CUSTOMERS #id buy # id *name * tax number * product o email # name sell * address Find the mistakes in the ERD related to Entities, Attributes and Relationships. Explain reason for these mistakes. Make necessary changes on ERD and present only effected structures (entities, attributes and relationships) A- B Iarrow_forward
- For whatever reason, a data object is not included in the data model.arrow_forwardTask Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table. Use SQL to create a new database (named MyCompany), then use it to build the relations mentioned above. Place the constraints (e.g., default values) you find appropriate.arrow_forwardAn Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settinarrow_forward
- Database Design [Image below] Before essential oil products are marketed, testing is carried out based on the production batch of each essential oil. This is done to maintain the quality and content of the constituents in the essential oil. Where the Test Percentage Content must reach the Minimum Percentage Content standard for each constituent. If there is one type of constituent that does not meet the minimum standards, the batch will not be marketed because it does not meet the quality standard. 1. If recording the results of each testing process is still done manually, in your opinion, please explain which approach is suitable between Centralized and View Integration for collecting requirements. 2. What Fact Finding methods will you choose to obtain information related to the development of a database system to record the testing process, and explain the reasons for choosing it.arrow_forwardWhy is it that a data object should not be included in a data model?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY

Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON

Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education

Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY