Data Base: Postgree SQL (Compulsory Use)

Data Base: Postgree SQL (Compulsory Use)

Subject: Secure Database Systems

Please read the scenario below carefully and then attempt the database design tasks set out below that.

Task 1: The Gill Art Gallery


The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer. A sample customer history form can be seen below. 


Using normalisation, produce a set of entities thinking carefully about appropriate use of entity and attribute names.

Normalisation Table: produce a normalisation table up to Third Normal Form (3NF) of the proposed system. The normalisation table should include the entities, attributes, primary and foreign keys.

Use the example in Appendix 2 as a template for your normalisation table.

Short Report: Write a report (of approximately 500 words) on any two potential database attacks which could occur on the Gill Art Gallery database. For each attack:

  • Include information relating to why the database might be a target for an attack,
  • the type of attacks which may occur; and,
  • the type of data that might be extracted from the system in each attack.

Remember to cite any resources using Harvard referencing.

Task 2: Millie’s Musical Emporium (MME)

Produce an E-R diagram and data dictionary for the following scenario. Ensure you think carefully about entity names and attribute names and data types.



Milllie’s Musical Emporium (MME) Ltd has grown from a small company based in a small market town, to one of the country’s leading suppliers of musical instruments and associated media (e.g. printed music, books, CDs and DVDs). However, they have never quite managed to move away from using a paper-based filing system for storing customer, sales, and stock information. To cope with their growth and allow for more efficient stock recording, the store has decided to computerise their customer management and stock recording system. You have been tasked with developing a database application to meet their needs.

 Current Position

 Currently, MME Ltd record details of all customers (including their name, address, telephone number, date of birth and bank details, i.e. bank name, address, sort code and account number) who either purchase a musical instrument or media. Records are also kept of every transaction that takes place in any of the stores.

A stock warehouse is also kept. This makes it possible to see where any given product (including its identifier, type, name, description, cost) is currently stored. The stock warehouse also contains details of all purchases and allows stores to move stock from one store to another. This is particularly useful for those customers who wish to purchase a product that is not available in their local store.

The organisation would also like to be able to create management reports, which may, for example, show all sales at a particular store or a group of stores, between certain dates.

Entity-Relationship Diagram: Using an Entity-Relationship (E-R) diagram, produce a design of the proposed system, correctly showing labelled relationships with cardinality constraints clearly indicated, using the notation taught in the module. You do not need to show attributes on the diagram, only entity names. Ensure that you state clearly any assumptions that you have made in creating your Entity-Relationship Diagram.

Data Dictionary: Using a data dictionary, specify a set of tables and appropriate attributes for your design from the Entity-Relationship diagram above. For each table, your data dictionary must specify:

  • Table name;
  • For each attribute, its name, description and data type (using PostgreSQL data types used in the SQL booklet for this module);
  • Primary key and any foreign keys (ensure you specify which table each foreign key relates to);
  • any further constraints on the data (e.g. business constraints on data values and dates; required format; and whether the attribute is null/not null).

 Use the example in Appendix 1 as a template for your data dictionary.

Appendix 1 – Sample Data Dictionary

The following is a sample data dictionary for the LEASE table from the property for rent database that you have been using during the module. It shows how the data dictionary must be laid out for each table.

Length is the maximum size permitted.

Required states ‘Y’ if the column is NOT NULL.

Validation states if there are any business constraints, e.g. the payment method can only be the character C or D.

Format specifies if there is any restriction on the format of the data, e.g. the rent_pm.

PK identifies attribute(s) which make up the primary key.

FK identifies whether an attribute is a primary key and indicates which table/attribute it relates to.

Comments are for any other relevant comments, e.g. to explain an attribute or validation constraints.


You need to submit your normalisation table and short report for Task 1 and E-R diagram and data dictionary for Task 2.  

The submission should be either a Word or PDF file.

Order Now

Struggling with Data Base: Postgree SQL (Compulsory Use) Assignment help? Take the best online service. Order Now!

No Fields Found.
Universal Assignment (June 7, 2023) Data Base: Postgree SQL (Compulsory Use). Retrieved from
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment - June 7, 2023,
Universal Assignment June 18, 2022 Data Base: Postgree SQL (Compulsory Use)., viewed June 7, 2023,<>
Universal Assignment - Data Base: Postgree SQL (Compulsory Use). [Internet]. [Accessed June 7, 2023]. Available from:
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment - Accessed June 7, 2023.
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment [Online]. Available: [Accessed: June 7, 2023]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

BAFI 3257 – Corporate Financial Management

School of Economics, Finance and Marketing Master of Finance BAFI 3257 – Corporate Financial Management ASSESSMENT TASK 3 – INDIVIDUAL ASSIGNMENT Semester 1 – 2021 Marks Due Date Submission Instructions Objective In this assignment, you are required to apply techniques and concepts acquired in this course to analyse and provide

Read More »

MMP742 – Investment Valuation

MMP742 – Investment Valuation Trimester 1, 2021 Assessment Task 2 DUE DATE AND TIME:                        Week 10, 17/05/2021, 8PM (AEST) PERCENTAGE OF FINAL GRADE:        25% WORD COUNT:                                   2,500 words Learning Outcome Details Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO) ULO 1: Collect, evaluate and interpret market data relevant to property

Read More »

Initial Instructions: Research Report

General Information For this assignment, the class will participate in a simple research project which you will write up as a research report with the following sections: Abstract, Introduction, Method, Results, Discussion and References. In order to successfully complete this assignment, you will need to I encourage you to work

Read More »

LST3LPC Policy Proposal

Due: Tuesday October 26 (11:59pm) Size: 1500 words Worth: 40% Submission: Turnitin Description Students are required to produce a policy proposal, including the discussion of a social issue, policy options and recommendations. To support students to complete this task comprehensively and in accordance with expectations for policy proposals produced outside

Read More »

HLT54115 Diploma of Nursing

Assessment 2: Literature Review- Evidence-Based Practice HLT54115 Diploma of Nursing CHCPOL003 Research and apply evidence to practice Instructions for Student Instructions Select one of the topics below and undertake a literature review using evidence-based Practice (EBP).   Topics The impacts of effective hand hygiene practices in nursing.Improvements in nursing interventions

Read More »

Assessment 2 – Narrated Presentation

Assessment 2 – Narrated Presentation Assessment Type Narrated Presentation of an Educational Resource Description: Teaching and Learning Outline.  In this assessment item you are required to: 1. Topic is: Blood Glucose level management and subcutaneous insulin application for patients with type 2 diabetes. 2. Conceptualise an educational resource that will

Read More »


FOOD PANDA Question 2 – Delivery performance measure Delivery Performance is the level at which an organization’s provision of products and services meets the criteria anticipated by its consumers. To achieve maximum client happiness, service providers must focus on quality. The top 2 approaches performance measure to evaluate their food

Read More »

BUSN3003 Exam – Session 2, 2021

BUSN3003 Exam – Session 2, 2021 Instructions: Please save this document onto your computer. Type your answers into the document, saving the document as you go – you don’t want to lose any answers! Once complete, upload the final document via the Turnitin Exam Submission Link on the Blackboard site

Read More »

Hospitality Services Management

Hospitality Services Management Group members: each doing 7 marks worth Chloe Kate Tori Gideon Assessment 2 Group Task – (using a Wiki) A Group Task, using a Wiki, to create a new service organisation Related Topics: 3, 4, 5 & 6. You have been assigned to a group drawn from

Read More »

Development and Construction – Assignment 3

Development and Construction – Assignment 3 Marking Guide This is a guide to help you with the structuring of your report and highlighting what specific information should be included in your report. You should use information from your previous assignments, including designs and the feasibility study, as the basis for

Read More »

Case Analysis Sarita

Sarita due Sunday 12 September 2021 2500 words ± 10% You will be marked against the criteria in the marking rubric for Case analysis. Theme  5 Stress response in health and illness and theme 6 Immunology concepts Weighting: 50% referenced using APA style. • ll written assessments are to be

Read More »

Assignment 1: Argumentative Essay

Assignment 1: Argumentative Essay Topic Healthcare professionals have an ethical responsibility to always advocate for the introduction of new treatments and technologies into healthcare. Instructions In relation to your selected topic: • Consider the application of the bioethical principles. • Consider the application of ethical theories and other ethical concepts.

Read More »

Healthcare Ethics Argumentative essay

ASSESSMENT INFORMATION   Assessment Title   Argumentative essay     Purpose The purpose of this assessment is for students to demonstrate the capacity to develop an ethical argument/s based around the four bio-ethical principles: autonomy, justice, beneficence, and non-maleficence. Students will use their chosen topic to develop a sound ethical

Read More »

Marking Guide for Assessment 1 Part B: Reflection

Marking Guide for Assessment 1 Part B: Reflection Reflection (Total of 30 marks) – Due 31st October 2021 Reflect on the desirable qualities of counselling and how these qualities shape your approach and values to counselling and/or developing a therapeutic professional relationship. Reflect on your PART A reflection and consider

Read More »

Critical Reflection scenario-based essay

Purpose: The purpose of this assessment is to deepen student’s understanding of the characteristics of leadership styles and the dynamic relationship of leadership with workplace communication and culture. Aim: This assessment provides the student the opportunity to apply and evaluate leadership styles in a scenario involving making changes to improve workplace

Read More »

MBA621 Healthcare Systems

Assessment 2 Information Subject Code: MBA621 Subject Name: Assessment Title: Assessment Type: Length: Case Study Slide Deck Individual PowerPoint presentation slides with notes 2000 words (+/- 10% allowable range) 20 slides with 100 words per slide Weighting: 35% Total Marks: Submission: 100 Online Due Date: Weeks 7 Your task Develop

Read More »

MATH7017: Probabilistic Models and Inference

MATH7017: Probabilistic Models and Inference, Project 2023                    (total: 40 points) Conditional Generation with Variational Autoencoders and Generative Adversarial Networks Overview In this project, you will work with Variational Autoencoders (VAEs) and Generative Adversarial Networks (GANs). You will build and train conditional versions of these models to generate MNIST digits given

Read More »

Surveying Plan Assignment Help

Submission Component and Marks Awarded Marks   PLAN:     Find Scale of plan and explain 4   9 Bearing and Distances of three lines 3 Plan Presentation 2 HORIZONTAL ALIGNMENT     Deflection Angles 4   18 Curve Elements 4 Chainages along the Road 10 VERTICAL ALIGNMENT:    

Read More »

NURBN3034 Assessment Task

NURBN3034 Assessment Task 1a Global Health Issues Group ePoster Presentation Weighting: 30% Due date: Thursday August 18th 13.59pm each group Purpose: The purpose of this learning task is to choose one of the following global health issues that under the right conditions has or is likely to have a significant

Read More »

ISYS3375 Business Analytics

School of Business, IT and Logistics — ISYS3375 Business Analytics Assessment 2: Case Study Assessment Type: Individual report                                               Word limit: 2000-3000 (+/– 10%) Each Table or Figure is counted as Due date: Sunday of Week 5 23:59 (Melbourne time) Weighting: 35% 50 words + the number of words in its

Read More »

NURBN3032 Task 2: Managing a Transition to Practice Issue

NURBN3032 Task 2: Managing a Transition to Practice Issue Weight: 60% Due: Thursday 18th May (Week 11) In this task, students are required to demonstrate knowledge relating to understanding and addressing a transitional issue that can affect new graduate nurses. Using evidence from current scholarly literature (i.e., less than seven

Read More »

ATS2561 Sex and the Media

Assessment Guide – Research Essay Due: Friday Week 12, submit on Moodle Weighting: 40% Length: 2000 words Write an essay responding to one of the following questions/topics: ‘objectifying’ images might be different, or that they should be understood as the same, for men and women. Your argument should address why

Read More »

ITC597 Digital Forensics

ITC597 Digital Forensics – SAMPLE EXAM ONLY This paper is for Distance Education (Distance), Port Macquarie, Study Centre Sydney and Study Centre Melbourne students. EXAM CONDITIONS: NO REFERENCE MATERIALS PERMITTED No calculator is permitted No dictionary permitted WRITING TIME:                     2 hours plus 10 minutes reading time Writing is permitted during

Read More »

Simulation Project- Computer Lab Project

Model and analyse the communication tower at the Casuarina campus. Apply dead, live and wind load as per in AS 1170 or other relevant standards in SAP2000. You should measure size of the elements as far as you can from or make reasonable assumptions about the dimensions. Reasonable assumptions should

Read More »

COM621 UX Strategy

Solent University Coursework Assessment Submission Module Name:    UX Strategy Module Code:    COM621 Module Leader: Assessment Submission Date: Student Number: UX Strategy Contents Part 1 – Introduction to System (1K words) 2 1.0 Introduction. 2 1.1       Current SUAA UX Design and Business Model 2 1.2       Academic and Market Research. 3 1.3      

Read More »

MIT302 Internet of Things

Group Presentation and Video (part 2) Unit:             MIT302 Internet of Things Due Date:       09/06/2023 Total Marks:    This assessment is worth 10% of the full marks in the unit. Instructions: 1.        Students are required to cover all stated requirements. 3.        Please save the document as: MIT302_Firstname_Surname_StudentNumber[assessment1].ppt Requirements: Write a PowerPoint of

Read More »

Can't Find Your Assignment?

Open chat
Free Assistance
Universal Assignment
Hello 👋
How can we help you?