This paper circulates around the core theme of 1. Explain the process of database development. Learners are also required to explain data models and identify and compare the chosen data model with one of the identified data models. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Unit 17 Art Gallery Database Design Concepts Assignment
Qualification | Unit number and title |
CSD | Unit 17 Database Design Concepts |
QFC Level | Credit value |
Level 5 | 15 credits |
Unit Code | Unit By | Submitted on |
R/601/0447 | Locus Assignment Help | |
Assignment title | Art Gallery Database Design |
Purpose of this assignment
To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as
Scenario:
Design a database for an art gallery. The database must keep information about artists like name, birth place, age, style of art and photograph. For each piece of artwork, it should store the information like the artist, the year it was made, its unique title, its type of art (e.g. painting, sculpture, photograph), and its price, along with picture (thumbnail). The database also stores information of customers. For each customer, database stores the person’s name, address and total amount of money spent in the gallery, invoice number and the artist and type of art the customer tends to like.
Task 1:
Analyse the key issues and application of databases within organizational environments. [AC1.1]
Critically evaluate the features and advantages of database management systems. Learners are required to explain the role of database administrator in database application development. [AC1.2 & M1]
Task 2:
1. Explain the process of database development. Learners are also required to explain data models and identify and compare the chosen data model with one of the identified data models. [AC2.1 & M2]
2. Draw entity relationship diagram also apply normalization up to 3rd normal form to design Art gallery database. Learners are also required to explain the steps taken for each normal form.
