Assignment related to er diagram

Assignment Help Database Management System
Reference no: EM13724577

Aim:
To give you practical experience in using Entity-Relationship and Relational Database modelling techniques.

Due Date:
MondayofWeek7(seeCourse Descriptionforfurtherdatesand times).

Project Specification
The proprietors of WareMart Logistics have approached you and asked if you could design a database to help them manage their business. They would like you to create a conceptual data model of their business information requirements and would like to see how the model could be used to provide the answers to some commonly requested queries and reports.
WareMart has provided the following information that it believes may be relevant to your task:
· WareMart Logistics Pty Ltd operates a large warehousing and transportation business. It has a number of warehouses around the country.
· Each warehouse is referenced by a warehouse number, and WareMart would also like to record street, city, state and postcode details.
· Each warehouse has a number of employees and WareMart references them by use of a Staff ID. In addition they record surname, first name, date of birth, street, city, state, postcode and salary details.
· Each warehouse has a single manager and a manager is responsible for only one warehouse.
· Employees do not report directly to the manager but to a fellow employee who has been given supervisor status.
· Merchandise is stored in warehouse ‘locations'. Each location reference is made up of an aisle, shelf and bin number component. As an example you will find a carton of product number 123 (Printing paper) in location 13,2,1 which refers to aisle 13, shelf 2, and bin 1. WareMart wants to know the capacity of each location, as well as whether hazardous materials can be stored there.
· A product can be stored in more than one location within a warehouse and a location can hold more than one product.
· Products are assigned a department and each department is referred to by a department number. WareMart also stores the department name for each department. The other information WareMart requires for each of its products is the product number, a description of the product and its pack size
· WareMart requires also the information on what quantity of each product is on hand at any given warehouse ‘location'. The location capacity and quantity on hand is in terms of the pack size of the product stored there.
· Clients are allocated a client number and this along with the client name is recorded. In addition each client has a main address, but may also have several others e.g. postal address, deliver-to address, etc. The individual address details recorded are: street, city, state, and postcode.
· A client may place several merchandise requests and WareMart needs to know the date a request was placed as well as the quantity for each of the products on that request. Once a request is placed a picking list is generated. Picking staff use this list to fill the client request. The picking list also has a spot for the employee to enter their staff id, the date the product was picked and the quantity picked from that specific location.

You are required to design (using an E-R diagram) an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each schema.

Assignment Submission
Youshould producea singlepdffile, created using Word,containingallof therequirementsasspecified within thisdocument. Yourlecturer willprovidedetails ofhowthefileis to besubmittedwithinlectures.

Thedesign documentshouldcontain:

1. A completedcopyof theSITEAssignmentCoversheet.
2. Anappropriatetitlepagethatincludesanacknowledgementofallstudentsyouhavespokento abouttheassignment.
3. A tableof contentsandautomaticallygenerated pagenumbers.
4. Anentityrelation (E-R) diagramthatmodelsthe problemwhichincludes:
a. all entities,relationships(including names)andattributes;
b. primary(underlined)andforeign (italic)keysidentified;
c. cardinalityand participation(optional /mandatory)symbols;and
d. assumptionsyouhavemade,e.g.howyouarrivedatthecardinality/participationfor those not mentioned orclearinthe businessdescription, etc.
TheE-Rshould becompleted usingthestandardsof thiscourse(crow'sfeet).

5. Normalisation of relations which identifies:
a. dependency diagram for each relation
b. the level of Normalisation achieved for each relation;
c. the reasons for any relation that is maintained NOT in 3NF.

6. Relational data structures that translate your E-R diagram which includes:
d. relation (table) names,
e. attribute (column ) names and field types (as required by WAMP),
f. primary and foreign keys identified;
The data structures should be shown using the standards of this course.

7. Abibliography,in APA format,containing all resources used to complete the assignment. If no resources have been used please indicate this appropriately.

Your assignment should be completed according to the University of Ballarat General Guide for the Presentationof AcademicWork.

Assessment Criteria

Question 1: How clear andwell-presented your submission is.
Question 2: E-R diagram:adherence too your standard,assumptions made,in clusion of correct primary and foreign keys,appropriate entities,relationships,and attributes.
Question 3: Normalisation:appropriate interpretation of each normal form,arguments for leaving the sche main the normal form you consider optimal.
Question 4: Conversion of E-R diagram to relational schema:schema is a correct translation of the E-R submitted with appropriate tables,columns,and primarykeys.

Reference no: EM13724577

Questions Cloud

Controversial methods of ending job discrimination : One of the most controversial methods of ending job discrimination is the concept of affirmative action. In a minimum 200 word response, discuss how affirmative action works to help ensure equal opportunity employment.
What organizational members say they value ethical practice : Symbols of culture are called artifacts. Artifacts are the most visible and accessible level of culture. These include behaviors, stories, rituals (everyday practices that are repeated frequently), and symbols (e.g., company logos, company colors)..
Summary of the concepts presented in the video : Write a 2 - 5-page summary of the concepts presented in the video that you found most relevant - what you learned from watching the video
Choose three major battles of the civil war : Choose three major battles of the Civil War. Identify each and thoroughly explain their impact on the war. 200 word minimum references and accompanying citations.
Assignment related to er diagram : Question 1: How clear andwell-presented your submission is. Question 2: E-R diagram:adherence too your standard,assumptions made,in clusion of correct primary and foreign keys,appropriate entities,relationships,and attributes.
Is it easier for businesses to lie to customers online : Corporate blogs, also known as business blogs, have opened the line of communication between businesses and customers. Is it easier for businesses to lie to customers online
Describe the different manifestations of progressivism : Describe the different manifestations of progressivism at the local, state, and national levels. To what extent did progressives redefine the role of the state of American politics?
Describe the cognitive and non-cognitive abilities : Describe the cognitive and non-cognitive abilities relating to Emotional Intelligence. Provide an example of how you might use EQ in your daily life. Respond to at least two of your peers for this posting with suggestions that might work for them ..
Was the target audience addressed : Online Video News Releases (VNRs) are visual storytelling that any business can use as a marketing and public relations tool. Was the target audience addressed

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain the diference between hash indexes and b+- ree index

Explain the difference between Hash indexes and B+- ree indexes. In particular, discuss how equality and range searches work, using anexample.

  Define calculations and format the table

internship at Mountain View Realty, a real estate firm that focuses in the North Utah County area. The previous intern developed a spreadsheet listing houses listed and sold during the last several months. She included addresses, location, list pr..

  Give preliminary information on data requirements for gis

You have been requested to give preliminary information on the data requirements for a GIS which is to be used to hold inventory of continental scale vegetation maps for coarse scale land surface

  What are some reasons for studying file systems

What are the advantages of having the DBMS between the end user's applications and the database?

  Design and implement an application that reads an integer

Design and implement an application that reads an integer value representing a birthdate from the user. First get the month, then get the day and then finally the year from the user.

  The chief financial officer

The chief financial officer (CFO) of NCWR keeps a huge number of reports, spreadsheets, and other critical financial information on his computer, which runs Windows 7

  Write down advantage in storing metadata in tables

What is meant by a Metadata? How does this term pertain to a database? Write down advantage is there in storing metadata in tables?

  Fishing in the public waterbodies of victoria rivers creeks

fishing in the public waterbodies of victoria rivers creeks lakes and reservoirs is controlled by the freshwater

  Finding the most expensive product item in the shopping cart

Your program needs to be able to find the cheapest product item in the shopping cart. For it you may adopt the same strategy described in Subtask 2.2.

  Companys traditional costing system-pacchiana manufacturing

Unit product cost of product R21V under the company's traditional costing system - unit product cost of product D00B under the activity-based costing system is closest

  Explain role of a database administrator

Explain the role of a database administrator,the tasks performed by this role and why this role is important in Database Management.

  Write a program that will open a blastn

Write a program that will open a BLASTN nucleotide to nucleotide search output file, parse out specific information, and produce formatted output that will be written to STDOUT

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