Art Gallery Database Design Concepts Assignment

Qualification - BTEC Higher National Diploma in Computing and System Development

Unit number and title - Unit 17 Database Design Concepts

QFC Level - Level 5

Unit Code - R/601/0447

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.

Task 3:
Create four or more tables for Art gallery scenario following the design which you have produced in task. Use the database tool provided to you to create the tables. [AC3.1]
Create the interfaces to access tables created for Art gallery database. [Create interfaces for all tables also create login form for user to get access to the database.
Learners are required to present implemented ART Galery database system to their tutor and classmates. [AC3.2 & M3]
Evaluate the effectiveness of the database created for Art Gallery whether it is fit for purpose or not. Also give some recommendations for future improvements. Learners are also required to support suggested recommendations and improvements with valid arguments. [AC3.3 & D1]

Task 4:
Create user manual for end user to know how to use the Art Gallery System. Also provide technical documentation for technical people to help in any technical issues.

Technical documentation must have:

Hardware Requirement
Constraints on tables
ER diagram
Database Schema
Table of Acronyms
Technical documentation must be supported with valid argument suggesting how they can be addressed

Learning outcomes:

LO 1
1.1 analyse the key issues and application of databases within organizational environments
1.2 critically evaluate the features and advantages of database management systems

LO 2
2.1 analyse a database developmental methodology
2.2 discuss entity-relationship modeling and normalization

LO 3
3.1 apply the database developmental cycle to a given data set
3.2 design a fully functional database (containing at least four inter-relational tables) including user interface
3.3 evaluate the effectiveness of the database solution and suggest methods of improvement
3.4 provide supporting user and technical documentation.

RELATED COURSES & ASSIGNMENT SERVICE!!


COMMENTS(0)

LEAVE A COMMENT


Captcha

 

 

Are You Looking for Unit 17 Database Design Concepts?


Order Unit 17 Database Design Concepts, Unit Code - R/601/0447 Assignment of BTEC Higher National Diploma in Computing and System Development, QFC Level - Level 5

When you duplicate others' works, you are emulating as well as copying. Will copied work be identified? Unquestionably! Presently those instructors in schools and colleges are as of now mindful of the huge number of simple access data in the Internet, in addition to those in the papers, magazines and books, they would need to ensure that their understudies will pass unique works. Anyway with regards to your non-copied article composing: postulation, thesis, research papers and so forth - inventiveness is as yet the way to guaranteeing that you will get better and reasonable evaluations. Also, how might they do it? 

A standout amongst the most exceedingly utilized and should we say 'trustworthy' site where instructors can transfer the papers put together by their understudies is through the Turnitin.com. By turning into an individual from this entryway, educators can get boundless access to their administrations and check every one of the papers copied and non-appropriated exposition papers of their understudies. In only a single tick, instructors will most likely recognize the degree of literary theft that the understudies submitted, which explicit parts are replicated and where was it duplicated from. They can make certain that an understudy turned in a non-copied paper or not 

We are Miracleskills, an organization that represents considerable authority in giving help to understudies who are experiencing issues doing their very own examination papers, proposal, expositions as well as papers. On the off chance that you request non-copied custom exposition from us - than we can take into account both the necessities of the understudies and the prerequisites of their instructors. We ensure that we give quality yields, however the best non-counterfeited assignment at that. So, do not squander your valuable time and appreciate the way toward enrolling for our most sought out Database Assessment Help services, which is being offered from the past several years

A study course in Database involves the study of an organized collection of data, generally stored and accessed electronically from a computer system. Further, we study the formal design and modeling techniques involved in the database system.  

All bits of homework conveyed by our experts under our Database Assessment Help administrations are thoroughly intriguing and novel. Each paper is absolutely high caliber in full comprehension with your hidden necessities. Further, upon solicitation, we likewise give turnitin report which gives the uniqueness file of the task. Our unique homework making organizations pass on papers out of amazing academic quality and regard. Your undertaking arranged under our Database Design Concepts administrations is triple checked to relate beginning essentials before it is sent to you. Further, if there should arise an occurrence of any disparity in the task, you can request revamps which will be given free of expense. Additionally, there are no confinements over the occasions you request revamps, we alter the write-up dependent on the directions given by you. 

We comprehend the significance of research in the write-up, thereby, our tutors experiences over 100K+ resources, present in our online library, in view of that the write-up are readied, making it sure that the review offered to you under Database Design Concepts is best in terms of value. Furthermore, dealing with the nature of the write-up, we guarantee straightforwardness in the administrations. In this way the customers who are enrolled with us under Database Design Concepts are permitted to realize the advancements made in the task from our end, this gives the customers a reasonable thought of the time by which they will get the write-up. Keeping our customers' close to home subtleties classified is our obligation. Under our Database Design Concepts administrations, we make it sure that none of your data is presented to any of the outsiders is in this way remained careful and secure. 

Remain ensured that your homework will be dealt with by our cultivated and learned organization experts. We mindfully enroll best autonomous writers to pass on assignments of stunning academic regard. Our organization gives every single understudy an exceptional critical opportunity to manage their assignments basically and successfully. Along these lines, presently quit squandering any longer time in looking for the Database Design Concepts specialist co-ops, as by clicking here, you have officially found the one required!