Find entity relationship and relational database modelling

Assignment Help Database Management System
Reference no: EM13317460

Aim:

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

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
• WareMartrequires 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

You should produce a single pdf file, created using Word,containing all of the requirements as specified within this document. Your lecturer will provide details of how the fileis to be submitted within lectures.

The design document should contain:

1. A completed copyof the SITE Assignment Coversheet.
2. An appropriate title page that includes an acknowledgement of all students you have spoken to about the assignment.
3. A table of contents and automatically generated page numbers.
4. An entityrelation (E-R) diagram that models the problem which includes:
a. all entities,relationships (including names) and attributes;
b. primary (underlined) and foreign (italic)keys identified;
c. cardinality and participation (optional /mandatory) symbols;and
d. assumptions you have made,e.g.how you arrived at the cardinality/participation for those not mentioned or clear in the business description, etc.
The E-R should be completed using the standards of this course(crow'sfeet).

5. Normalisation of relations which identifies:
a. dependency diagram for each relation
b. the level of Normalisation achieved for each relation;
c. thereasons 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 APAformat,containing all resources used to complete the assignment. If no resources have been use d please indicate this appropriately.

Your assignment should be completed according to the University of Ballarat General Guide for the Presentationof AcademicWork.This isavailable onlineatthefollowing web address:

https://www.ballarat.edu.au/generalguide

Reference no: EM13317460

Questions Cloud

Which should be identical to the json : Modify the attached code to include a exportToJSON method within the Cave object. This method should output the JSON version of our Cave, which should be identical to the JSON within Cave.dat for that particular Cave.
Assess the potential abuses of companies using a market : While US GAAP requires assets to be valued at the lower of cost or market, there is a belief that assets with value fluctuations should be valued at market and adjusted on a regular basis. Create an argument supporting the use of market value for inv..
A price compromise between buyer and seller is known : Gruel is an inferior good. Hence, an increase in consumer income decreases the supply of gruel increases the supply of gruel decreases the demand for gruel increases the demand for gruel
A private closed economy includes households : A private closed economy includesA.households, businesses, and international trade, but not government. B.households, businesses, and government, but not international trade. C.households only. D.households and businesses, but not government or inter..
Find entity relationship and relational database modelling : 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.
Researchers discover that tomatoes reduce cancer and the : Susan begins to examine shifts in demand for shoes. She discovers that as the population increases then it is likely that there will be a shift in demand to the right for shoes. She also discovers that when there are more houses being built, sometime..
Explain how ricardian equivalence works : Explain how Ricardian Equivalence works and explain how to get the quantity theory from the equation of exchange
Define market imperfections : Using your own words, define market imperfections. To support your definition, include at least two examples. Do not include the examples from the book create your own examples.
The gdp fails to capture changes in the availability of leis : The GDP fails to capture changes in the availability of leisure time and often fails to reflect changes in the quality of products or in the availability of new products." Discuss this statement from the textbook. Why is this so?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Create an idefix or er diagram for the database

Import your IDEF1X diagram into Oracle and create the appropriate tables and relationships. Your design should include a specification of tables, attributes, primary and foreign keys, referential integrity constraints, and referential integrity ac..

  Design data file grades with records of form

Input names of students from user, terminated by ZZZ, and design the data file GRADES with records of form: student (string), test1 (integer), test2 (integer), test3 (integer).

  Key functions of organization-map to strategic information

From information system point of view, we should take the key functions of organization and map them to strategic information. Do your companies follow this process or are steps skipped?

  How to improve the quality of datasets

Recommend at least three (3) specific tasks that could be performed to improve the quality of datasets, using the Software Development Life Cycle (SDLC) methodology. Include a thorough description of each activity per each phase.

  Physical schema created for a database

At this point in the design process, you would have a detailed physical schema created for a database. How would you approach converting your schema into a database, complete with sample data? Explain your approach in two to three paragraphs.

  Performance of a distributed database

How can replication help the performance of a distributed database and in what situations can replication hurt the performance of a distributed database?

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  Discuss the serious data redundancy problems

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure and looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

  Create an erd and relatioal schema

Create an ERD and relatioal schema in third normal form based upon the following business rules. (Hint: ensure that all attributes are FULLY DETERMINED by the primary key.) Don't forget to place your normalization arrows on your relational schema.

  Database planner should spend a considerable amount of time

Provide what reports may be produced as a result of your database design.Based on the information you have researched, create a 2-3 page design document that includes a description of the database you would like to create as well as sample tables ..

  Use sql to create database

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

  Converting user form into 1nf and 2nf

Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

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