Design a database from a list of requirements

Assignment Help Other Subject
Reference no: EM131949296 , Length: word count:1500

Spreadsheets and Databases for Business Analysis

Introduction

The module provides an overview of the advanced use of spreadsheets and databases for business management and analysis. The use of spreadsheets and databases are key skills for business employers.

This booklet contains:
- an introduction to the module
- lecture and seminar locations
- details of recommended reading
- information on assessment and feedback, including the coursework
- an overview of the entire module

Coursework Brief

You must design a database from a list of requirements based on the contents of lectures, producing an entity-relationship diagram, a determinancy diagram and a relational schema, with a detailed account of how the requirements have been translated into the diagrams. These should be submitted in a Word file.

Design a database system to maintain data associated with a company. The text below has been produced from a requirements elicitation exercise.

- The company has some factories for production, as well as one sales office.
- Each factory has several production departments, and the sales office includes a number of subdivisions.
- In each production department, a manager oversees its overall operation, as well as all workers working in the production department.
- Production departments produce both product parts and products.
- Each product is comprised of a number of product parts, and each product part could be used to make up multiple products.
- Both products and product parts are stored in the warehouses owned by each factory.
- Each product is only produced by one factory and sold by one subdivision of the sales office.

(a) Produce an entity-relationship diagram which represents the domain of the company, together with the detailed explanations and justifications of each entity, relationship, cardinality, and participation constraint in the diagrams. Note that some attributes should be created and assigned to the entities in the domain.

(b) Produce a determinancy diagram to document the dependencies between data- items, together with clear and reasonable explanations and justifications.

(c) Accommodate both the entity-relationship diagram and the determinancy diagram produced to a relational schema expressed in the bracketing notation.

Referencing is Harvard style

Reference no: EM131949296

Questions Cloud

Write arm program that implements game micro space invaders : Write an ARM assembly language / C program that implements the game Micro Space Invaders, as described below.
What are four important tactical tasks for negotiator : What are four important tactical tasks for a negotiator in a distributive situation to consider?
Methodology for doing software development : The IT department has its own methodology for doing software development. The engineering department has its own methodology for doing new product development.
Project procurement management processes : "The various activities involved in the Project Procurement Management processes form the life cycle of an agreement. By actively managing
Design a database from a list of requirements : MN-3526 Spreadsheets and Databases for Business Analysis - Design a database from a list of requirements based on the contents of lectures, producing
Difference between accounting value and market value : Explain the difference between accounting value and market value.
Understand the current system : There has always been much debate about the value of work and time required to understand the current system and/or process
Calculate the addition to retained earnings expected : Calculate the addition to retained earnings expected in 2016.
Contract and negotiations best practices : Why is determining who has authority an important activity in conducting a negotiation?

Reviews

len1949296

4/19/2018 5:26:24 AM

Referencing is Harvard style I have assessment that needs doing as well. The assignment details are attached below- ITS ASSIGNMENT 2 that needs to be done. Assignment 1 was already completed. For this peace of work I really need 90%+ so if you have experts that can produce that sort of standard then we can get to work. Once you can confirm with me or not I will send you the lecture notes relevant for the coursework and main textbook details. To achieve high marks in this module students will need to do the background and supplemental reading as well as conduct their own independent research for instance through the reading of academic journals, into the topics identified.

len1949296

4/19/2018 5:25:58 AM

Assignments are a critical part of the learning experience and development for scholars at Swansea University. Practice will pay dividends when it comes to honing your skills in report and essay writing. Students are therefore encouraged to submit the highest quality work they can to reach their maximum potential. Students with concerns about how to present their work can consult with the Module Co-ordinator for guidance in addition to the notes listed below: The word limit for individual coursework assignment (excluding tables, calculations, charts, graphs, figures) is 1,500 words. The word count must be stated in the assignment cover sheet.

len1949296

4/19/2018 5:25:50 AM

Please note: • The maximum file size that can be uploaded is 20mb. If your file is larger than this it is usually because you have included a lot of images – you should either remove some if possible, or else convert them to a more efficient format to bring the file size down (e.g. .png or .gif). • You should ensure your student number is in the title of the filename for the work you submit/upload. • The School of Management operates a late penalty system as follows: when work is submitted late with no prior authorisation, a penalty of 10 marks will be deducted from the actual mark for each calendar day, or part of a day, by which the deadline is exceeded. After seven days from the initial deadline, a mark of zero will be awarded. Late work should be submitted electronically in the usual way.

len1949296

4/19/2018 5:25:40 AM

Key Marking criteria will include: Accuracy: Accuracy of the diagrams and their presentations Assignment Structure: clarity of structure and presentations Writing Quality: Readability and ability to convey key message(s) concisely and logically Insightfulness of Analysis: Interest and usefulness of findings, conclusions drawn Understanding: Demonstration of understanding of the key topics Evaluation: Evidence of independent thinking and critical awareness Overall Quality of Assignment

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd