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.

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.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: esign a RELATIONAL SCHEMA not an ERD for the pllowing A job-shop accounting system is part of an…

A: Here we describe all points:

Q: Create Use Case descriptions for the use cases depicted in the diagram above

A: A "Use Case" in Unified Modeling Language (UML) is a graphical illustration of a device's…

Q: n an EER diagram for a database used to manage a racket sport association (for example, US Tennis…

A: ER diagram description: ER diagram indicates the relationship between one entity to any other…

Q: Case Study: National Football League (NFL) Suppose you are given the following requirements for a…

A: Objects (Entities) and Attributes:TeamsNameCityCoachCaptainPlayersNamePositionSkill LevelInjury…

Q: How do different programming languages or frameworks approach data binding?

A: Data binding is a crucial concept in software development that enables synchronization between the…

Q: Explain the concept of data binding in the context of software development, and provide an example…

A: Software development is the systematic process of designing, creating, testing, and maintaining…

Q: Please explain the meaning of the term "data-structure." Can you explain the various data…

A: Data Structure: The data element group, or data structure, helps preserve, organise, and utilise…

Q: Design UML for the following set of requirements for a university database that is used keep track…

A: UML : UML stands for Unified Modeling Language. It is one type of form where visually representing…

Q: Suppose you were designing a file of student records for your university’s placement office. One of…

A: The question has been answered in step2

Q: Q1) Draw the ER Diagram for the scenario below. The company database keeps track of company's…

A: The Entity-Relationship (ER) diagram provided above captures the essential elements of a company…

Q: In the context of data binding, explain the terms "source" and "target" and how they relate to each…

A: In the context of data binding, "source" and "target" are two fundamental terms that help to explain…

Q: Regular entity type is transformed to a relation.

A: To be determine: Regular entity type is transformed to a relation.

Q: Assume that you are an employee of a consultancy company that specializes in the analysis, design,…

A: Executive summary: This report aims to provide an overview of the fact finding techniques that will…

Q: Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed.…

Q: Using SQL, develop and execute the following queries:

A: 1. select sname,sid from student where gpa>2.5 AND gpa<=3.5; 2. select s.sname,c.cname from…

Question

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

(b) Define the following structures: Manufacturer name manufacturer’s name country : origin Vaccine : vaccine name (e.g. Pfizer) : vaccine type (e.g MRNA) : total price : total shots : Manufacturer type name type price (e.g. $28.5) (e.g. 2 shots) noofShot mf
C++ What is relation? Define the properties of a relation.
The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies. Q: Suppose a single relation “Movie” which contains all attributes of all…
Break the list in Figure 1-31 into tables, each with a single theme. Create ID columns as you think necessary.
Task 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.
Create 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.
What is the point of leaving a data object out of a data model?
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…
Computer Science It is needed to design a database system for a pharmacy. The pharmacy contains many different items. Items may be products or medicines. Medicines are classified into different types either bills, injection, capsule or drugs or any combination of them. An item must be supplied by only one supplier. A supplier may supply many type of items. A customer may order many items. The pharmacy has a unique name, address and more than one telephone. The doctor can prescribe one or many medication, injections can not be bought without a doctor prescription. You are requested to draw the EERD diagram for the described system You are required to write down any assumptions made from your side You should add the attributes and cardinality for all the entities You are required to model the EERD into relational model
Computer Science Relational Model (Logical and Physical Schema Development) The conceptual model developed in phase 2 will be transformed into a logical and physical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema should have the following components: Set of required relations All the integrity constraints Submission and Evaluation: A report consisting of the problem statement, ER diagram, relational schema And implement the database using SQL should include: All the tables properly defined /created All constraints properly defined For each table, few instances of data should be entered.
The textual description nodan, describes a video rental company that wants to create one database of its activities. Drawing an ER chart sim meets the company's requirements. The company has stores throughout New York. What is stored about each pile is the telephone number and address which consists of street, city, house number and postcode. Each store is also assigned a number that is unique throughout the company. There is always a manager for each store. An employee thus has a specific role. If employees, they also store names and salary. Each employee has an employment number that is unique Each store has a video store. Information about the film / video that is of interest, video number, title, status and the names of the most important actors, and the director. The rental price for a film varies depending on which store you rent the film from.Of course, the role of a preson participant in one film may vary in another film Shelf numbers and number of copies of each film are also…
True or false Statement: 1) We need to create a separate table for the "supported Component' attribute of the "operating System" entity type A) True B) False MCQS: 1)When mapping the "purchase relationship" type, the foreign key we add has the following constraint(s) 2)The primary key of the "operating_system" table is