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

Scenario:

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. 

Requirements:

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.

Scenario:

Introduction

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.

Guidelines

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 (November 28, 2023) Data Base: Postgree SQL (Compulsory Use). Retrieved from https://universalassignment.com/data-base-postgree-sql-compulsory-use/.
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment - November 28, 2023, https://universalassignment.com/data-base-postgree-sql-compulsory-use/
Universal Assignment June 18, 2022 Data Base: Postgree SQL (Compulsory Use)., viewed November 28, 2023,<https://universalassignment.com/data-base-postgree-sql-compulsory-use/>
Universal Assignment - Data Base: Postgree SQL (Compulsory Use). [Internet]. [Accessed November 28, 2023]. Available from: https://universalassignment.com/data-base-postgree-sql-compulsory-use/
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment - Accessed November 28, 2023. https://universalassignment.com/data-base-postgree-sql-compulsory-use/
"Data Base: Postgree SQL (Compulsory Use)." Universal Assignment [Online]. Available: https://universalassignment.com/data-base-postgree-sql-compulsory-use/. [Accessed: November 28, 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.

Categories

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 info@universalassignment.com . 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

5 Places you must visit in Busan, South Korea

Write 2 articles 1st Topic: 5 Places you must visit in Busan, South Korea 2nd topic: Korean language: various tips and resources to learn Deadline: 10th October 2023 12:00 AM Instructions: Article Structure is given below Meta Description: First, you will start with a meta description of your article in

Read More »

2002HSV Human Services Research

Assessment 2: Written research proposal Worth 45% of final grade Complete your answers in this assignment template Name: xxxxxxx Student ID: xxxxxxx Title: xxxxxxx Exact word count (exc. cover sheets and reference list; max. 2,000 words): x,xxx Please specify the research methodology are you proposing to use: ☐ Quantitative                                    ☐

Read More »

COIT29226 Introduction to IoT

Assessment item 3 – Project Due date: Week 12 (8 October 2023) 11:55 pm AEST Weighting: Length: Submission: 50% There is no word limit for this report Group work (submit via Moodle) Objectives This assessment item relates to the following unit learning outcomes: Learning Outcomes Assessed: Enabling objectives What do

Read More »

BUSM1008 Assessment 2 Brief Spring 2023

Assessment 2: Individual Report (20%) and Presentation (20%) Background You are appointed as a business consultant, recruited by the company allocated to you in week 6 by your tutor.  Your role is to undertake research on the company, the allocated topic and an issue identified in the media in relation to your company and

Read More »

ECON1020 PRINCIPLES OF ECONOMICS

INDIVIDUAL ASSIGNMENT Total Marks 100 | Weighting 25% DUE: 29/09/2023, 11:55pm IMPORTANT INFORMATION: READ BEFORE YOU START SUBMISSION 11.55 pm. A 1-hour grace period is provided to students who experience a technical concern. DOCUMENT PREPARATION REFERENCING UNACCEPTABLE ACADEMIC ACTIVITIES MARKING Question 1 | [12 marks] Download the spreadsheet data that

Read More »

ENTERPRISE LAW LAWS1001

Assessment task 3 Individual Case Study This task is the result of your individual effort, so students must not discuss their work with anyone else, otherwise it may lead to an allegation of collusion. Weight: 15% Due: Before 5 pm on Wednesday 27th September. Late submissions will incur a penalty

Read More »

International Business INBU01-7

Module International Business INBU01-7 (NQF LEVEL 7) FORMATIVE ASSESSMENT – ASSIGNMENT C Assignment C (INBU01-7/DLO4 10/2023) Exam Date 20 October 2023 Marks 50 Assignment C (INBU01-7/DLO4 10/2023)   Total: 20 marks SECTION A (10 MARKS) – PARAGRAPH QUESTION Question 1 (10 marks) Coca-Cola is marking its 70th year in Nigeria

Read More »

Summative Assessment Help

Summative Assessment Brief: Learning Outcomes: LO1: Construct a problem/issue/need identified from practice that impacts on individual outcomes LO2: Formulate a focus-based enquiry on the identified problem/issue/need utilising an area of individual learner interest LO3: Critically evaluate the evidence base to support the proposal of the solution focused initiative LO4: Develop

Read More »

EDU30067 Teaching English

Assignment 2: Folio Template INTRODUCTION:         LESSON 1 Lesson title:   Year level: Topic:   Duration of lesson: Curriculum links: Strands & sub-strands Content descriptions       Students background knowledge: What is your starting point – what do the students already know, what have they done

Read More »

Edge Computing Security and Privacy

Proposal Background Title: Edge Computing Security and Privacy Proposal The new computing paradigm in the Internet of Things domain is known as IoT edge computing which functions by processing calculations at the edge of the network (Alli & Alam, 2020). The current technology aided by cloud and fog computing has created

Read More »

Foundations of Communication Assessment 2 Instructions

Discussion task (Total grade – 10%)   Process Work (Steps to complete the task) Answer on the Assessment 2 Submission Document – Do not upload this instruction document. Requirements (important elements to include) lastname_firstname_studentID_COMS_Assess 2_semester_year. Process for Assessment discussion tasks NOTE: If you do not participate in the class discussions then

Read More »

Assessment Two Dos and Don’ts (Internal)

Do: Read the assessment instructions carefully Read the marking rubric carefully Understand the question – break it down Conduct research – record the reference details Read the topic materials about communication theories, forms and factors and refer to them Contribute to the discussions in class or no marks for the

Read More »

Unpacking the Question: Assessment Two

Studying at university requires you to become familiar with strategies to un-pack or breakdown a variety of assessment questions/tasks throughout your studies.  Task Example of integrating the discussion, research and theories. In the group discussion my group members (name them) stated that an advertisement for a beauty product would most

Read More »

MGMT0001 Introduction to Commerce Assessment

MGMT0001 Introduction to Commerce Assessment 2 (worth 30%) Due date:                  2:00pm (AWST) Friday 15th September 2023 Submission:              Via Turnitin assessment submission link (see ‘Assessment 2’ folder in ‘Assessments’ section of Blackboard). Additional Instructions: Part A (42 marks) Nathan is a well-known chef with years of experience cooking various cuisines. After

Read More »

ACCT5011: Accounting Systems in the Digital Age

Practical Assignment Guide, Semester 2, 2023 Due Date for Submission: Monday 11th September 2023 at 5.00 PM Please note that the Folio Assignment for ACCT5011 Accounting Systems in the Digital Age is an individual assessment task worth 30% of your total marks in the unit. Please refer to the online

Read More »

EC229- Review session

Assume two cities, A and B, that can’t trade between them. Each city produces its own coconuts for its local market. If suddenly trade is possible then: D) As we saw in class, the new price will be somewhere between the original price 𝑃_𝐴,𝑃_𝐵. Hence it is impossible for consumers

Read More »

Computing Theory COSC

Computing Theory COSC 1107/1105 Assignment 1: Fundamentals Assessment Type Individual assignment. Submit online via Canvas → As- signments → Assignment 1. Marks awarded for meeting re- quirements as closely as possible. Clarifications/updates may be made via announcements/relevant discussion forums. Due Date Week 6, Sunday 27th August 2023, 11:59pm Marks 125

Read More »

BE279 Applied Statistics and Forecasting

Strategy, Operations, & Entrepreneurship Group Essex Business School Module Code BE279 Module Title Applied Statistics and Forecasting Assessment Type Individual Report (2,000 word) Academic Year 2022/23, Spring Term Submission Deadline Refer to FASER Task Specific Guidance Please note that: Module Learning Outcomes On successful completion of the module, students will

Read More »

Learning Design Tool: Little Learners Level 1 sounds

Learning Design Tool: Little Learners Level 1 sounds. Prepared by Sara Hart Date 30th August, 2023 (feel free to leave this date as it is the AT2 due date) Brief description of Learning Design   Chooseit Maker: Create, edit and play personalised learning activities that can be used in your

Read More »

HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT

HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT 1 TEMPLATE This assignment is made up of three (3) parts, plus a reference list and appendix. Marks are allocated for each section, as follows: – 1 mark Please ensure that you provide your answers in this template, and provide a Reference list

Read More »

Model 3 Launch in Australia

Client Information Company Name Tesla Contact Name   Email   Phone Number   Address Level 14, 15 Blue St. North Sydney, NSW 2060 Australia Ad link & image Project Information Project Title Model 3 Launch in Australia Project Description (100 words) Highlight the uniqueness of the car. Show the superior

Read More »

MKT10009 Marketing and the Consumer Experience

School of Business, Law and Entrepreneurship Assessment Task – Assignment 2  MKT10009 Marketing and the Consumer Experience Semester 2, 2023. Assessment Type Analytical Report Associated Unit Learning Outcomes (ULO’s) 2, 3, 4 Group or Individual task Individual Value (%) 25% Due Date Monday 20th September at 10:00 AET – Enterthis

Read More »

ASSIGNMENT – 1st Evaluation

ASSIGNMENT – 1st Evaluation Date of Submission- 4TH SEP 2023 25 MARKS COMPARATIVE PUBLIC LAW Q. You are the new Central Minister for Urban Development who is keen to make major Indian cities as smart cities. You visit different countries like USA, UK, European Countries, Japan and other developed countries

Read More »

Corporate & Financial Due Diligence Report

[Name of the company] Note: Students should keep in mind that application of legal provisions (including Securities Regulations) and analysis of the same is important. Merely putting the facts and figures won’t fetch even a decent mark. Note: Students should only mention the broad area of business. This part should

Read More »

ECON1000 S2 2023 – Marking Guidance and FAQs on GTP

Students will be marked on the extent to which they specifically answer the question and provide clear, logical, well-reasoned and sufficient explanations. Here is a summary breakdown of how marks are allocated in this GTP: Part 1 [15 marks] §  Providing relevant observations from the information provided in the articles

Read More »

ECON1000 S2 2023 – GTP Brief

ECON1000 S2 2023 – GTP Brief A.  Context and Overview The Game Theory Presentation (GTP) is worth 30% of the final mark. GTP is a ‘take-home’ exercise with a set of tasks to do. The GTP is based on Lecture Topics: L1 and L2. You will have twenty (21) days

Read More »

Order #35042 Human Rights Research Essay

Draft due 26th Aug 2,500 words (excluding references and bibliography) Instructions: Structure: Title – The Tigray War: A Critical Analysis of What the Future Holds for Human Rights in the Region What can be done to ensure human rights violations will cease and be prosecuted? Expand on different actors and

Read More »

PMC1000: Applied Pathology

Assessment Task Sheet: Poster Presentation Date: Thursday 31st August 2023 | Weighting: 30% Assessment Task 2 You are required to develop a handout style resource (pamphlet or brochure) on a selected pathological condition which is aimed at first year student paramedics. You will need to use high quality peer reviewed

Read More »

Detailed Information: Reflective Assignment

Indigenous Peoples, Law and Justice Detailed Information: Reflective Assignment Due Date:                   Tuesday 5th September 2023 at 4:00 pm (AWST). Marks:                       30% of the total marks for this unit. Assignment:              The assignment will comprise two questions. Students must answer all parts of both questions. Examinable topics: The cultural immersion exercise and/or

Read More »

Can't Find Your Assignment?

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