To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as
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 persons 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.
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]
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.
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:
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
2.1 analyse a database developmental methodology
2.2 discuss entity-relationship modeling and normalization
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.
MPOM7103 Assignment: Strategic Decision-Making and Operational Resilience in Petronas Amid Energy Transition
Read MoreMPIB7103 Assignment: Critical Perspectives on International Business Strategies and Regional Integration
Read MoreMPHR7113 Assignment: Strategic HR Analysis of Golden Heritage Café (HRM)
Read MoreTHEA1013 assignment: Theatrical Storytelling: Exploring the Unique Power of the Stage
Read MoreBusiness Strategy Assignment: Strategic Expansion: A Business Outlook
Read MoreGSGM7324 Assignment: Organisational Development and Change Management
Read MorePHY098 LOD 2, C4 Assignment: Mitigating Damage to Electrical Appliances from Lightning Strikes
Read MoreBM070 Business Research Assignment: Business Report Framework for Corporate Development
Read MoreHBET1203 Assignment: Comparing Pronunciation of Selected Words in Text and Reading to Standard British English
Read MoreIdentify key technological challenges affecting e-invoicing adoption in Malaysia.
Read More