Veritabanı Vize 1. Sorusu ve Cevabı
Soru yazının sonundadır diyerek yazmaya başlıyorum.Sorunun cevabını sınavdan hemen sonra bulmak kötü olsa da EER diyagramının nasıl yapılacağını öğrendim.Hoca derste soruyu çözdü ama yazamayanlar ya da derse gelmeyenler olabileceği düşüncesiyle cevabı paylaşıyorum.Hayrını görün,görelim.:D
Design a database to keep track of information for an art museum. Assume that
the following requirements were collected:
• The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique
IdNo, an Artist (if known), a Year (when it was created, if known), a Title, and
a Description. The art objects are categorized in several ways, as discussed
below.
• ART_OBJECTS are categorized based on their type. There are three main types:
PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate
objects that do not fall into one of the three main types.
• A PAINTING has a PaintType (oil, watercolor, etc.), material on which it is DrawnOn
(paper, canvas, wood, etc.), and Style (modem, abstract, erc.).
• A SCULPTURE or a STATUE 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.
• ART_OBJECTS are also categorized as PERMANENT_COLLECTION, which are owned by the
museum (these have information on the DateAcquired, whether it is OnDisplay
or stored, and Cost) or BORROWED, which has information on the Collection
(from which it was borrowed), DateBorrowed, and DateRetumed.
• ART_OBJECTS also have information describing their country/culture using information
on country/culture of Origin (Italian, Egyptian, American, Indian,
etc.) and Epoch (Renaissance, Modem, Ancient, etc.).
• The museum keeps track of ARTIST'S information, if known: Name, DateBom (if
known), DateDied (if not living), CountryOfOrigin, Epoch, MainStyle, and
Description. The Name is assumed to be unique.
• Different EXHIBITIONS occur, each having a Name, StartDate, and EndDate.
EXHIBITIONS are related to all the art objects that were on display during the
exhibition.
• Information is kept on other COLLECTIONS with which the museum interacts,
including Name (unique), Type (museum, personal, etc.), Description, Address,
Phone, and current ContactPerson.
Draw an EERschema diagram for this application. Discuss any assumptions you
made, and that justify your EERdesign choices.
the following requirements were collected:
• The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique
IdNo, an Artist (if known), a Year (when it was created, if known), a Title, and
a Description. The art objects are categorized in several ways, as discussed
below.
• ART_OBJECTS are categorized based on their type. There are three main types:
PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate
objects that do not fall into one of the three main types.
• A PAINTING has a PaintType (oil, watercolor, etc.), material on which it is DrawnOn
(paper, canvas, wood, etc.), and Style (modem, abstract, erc.).
• A SCULPTURE or a STATUE 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.
• ART_OBJECTS are also categorized as PERMANENT_COLLECTION, which are owned by the
museum (these have information on the DateAcquired, whether it is OnDisplay
or stored, and Cost) or BORROWED, which has information on the Collection
(from which it was borrowed), DateBorrowed, and DateRetumed.
• ART_OBJECTS also have information describing their country/culture using information
on country/culture of Origin (Italian, Egyptian, American, Indian,
etc.) and Epoch (Renaissance, Modem, Ancient, etc.).
• The museum keeps track of ARTIST'S information, if known: Name, DateBom (if
known), DateDied (if not living), CountryOfOrigin, Epoch, MainStyle, and
Description. The Name is assumed to be unique.
• Different EXHIBITIONS occur, each having a Name, StartDate, and EndDate.
EXHIBITIONS are related to all the art objects that were on display during the
exhibition.
• Information is kept on other COLLECTIONS with which the museum interacts,
including Name (unique), Type (museum, personal, etc.), Description, Address,
Phone, and current ContactPerson.
Draw an EERschema diagram for this application. Discuss any assumptions you
made, and that justify your EERdesign choices.
sağolasın =)
YanıtlaSil