Database Architectures and Technologies
Database Architectures and Technologies
Case Study
The Oman National Museum is an art museum that presents the art histories and contemporary art practices of Oman and other regions. The collection includes paintings, sculptures, multimedia installations, drawings, prints, and photographs, among others.
Each art object has a unique ID number, title, description, artist, and year. Art objects are mainly categorized based on their type. There are three main types: painting, sculpture, statue and the remaining objects can be categorised as others.
A painting art work has paint type such as oil, watercolour, etc. The materials on which it is drawn are paper, canvas, wood, etc., and a style such as modern, abstract, etc. A sculpture art work has a material from which it was created such as wood, stone, etc. and also it has the height, weight, and style.
An art object in the other category has a type such as print, photo, style, etc. Art objects are also categorized as permanent collection that are owned by the museum, which has information on the date acquired, whether it is on display or stored or borrowed. It has also information on the collection (from which it was borrowed), date borrowed and date returned. Art objects have information describing their country/culture of origin (Indian, Egyptian, American, etc.) and era such as stone age, renaissance, etc.
Furthermore the museum keeps track of artist’s information such as name, date of birth, country of origin, main style, description, and the name is assumed to be unique.
Exhibitions occur frequently each having a name, start date, end date and is related to all the art objects that were on display during the exhibition. Moreover, the description, address, phone, and current contact person for each exhibition need to be stored.
question:
Part B: Database Architectures and Technologies – 30% of the marks for the module.
Assume that this database for ITS Centre for Staffordshire that you developed has one main branch with four sub branches. Now they decided that the remaining 4 branches should also use this system. You are expected to research the architecture of your chosen DBMS in detail and relate this to the scenario. The answers which reproduce general principles from the lecture notes or simply paraphrase the vendor web site will be marked down.
requrment:
- i. ITS Centre is considered to implement a cloud based database. Describe the process of converting this database into cloud based database. Also create a cloud database architectural diagram for the same scenario. Critically evaluate the process.
(15 marks)
II. Further ITS Centre wants to apply data mining technique in the cloud database to manage the volume of the data. So evaluate the process of data mining technique in the cloud.
(5 marks)
- What are some examples of non-relational databases, and where/how are they used in the real world? Why would you choose to use a non-relational database over relational databases?
(10 marks)
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
