Assignment related to er diagram

Assignment Help Database Management System
Reference no: EM13724577

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

Concept of entity in a process

Question 1: Use an example to explain what is an entity in a process? What is an attribute? Question 2: Define a measure that can be used to judge a code's quality. Name one s

Draft the requirements for the new web site

Draft the requirements for the new Web Site - questions including all the SQL scripts that you may have created. You also must provide screen shots of specific portions of th

What factors will influence how you design the database

The small publishing company you work for wants to create a new database for storing information about all of its author contracts. What factors will influence how you desig

List and discuss the four transaction properties

1.Write two to three paragraphs answering each of the following questions: a What are the three types of database critical events that can trigger the database recovery proc

Develop a model using an excel spreadsheet

Develop a model using an Excel spreadsheet to project financial statements for Rama's Lawn Mowing -  find how many jobs per year would be required for Rama's company to break

What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing even

Allows users to view and register for classes offered

Users will be able to register in order to use the system. If the user is register they will be prompted to enter their username and password to navigate through the system.

Normalize the following relations to 3nf

Do you always have to use the third normal form? Why or why not? What can happen if you do not use the third normal form? Normalize the following relations to 3NF, using the s


Write a Review

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