Phone: + 1 507 4052 660

Er diagram, normalization, relational structure only


Project Specification

The proprietors of BigM have approached you and asked if you could design a database to help them manage their business. The management has commissioned you (in your capacity as a Database Management System consultant) to analyse, design and develop an appropriate conceptual data model and relational database schema, based on the following information gathered about the current business activities.  


  • BigM operates stores in many cities in Australia. Stores are referenced by store number. BigM also keeps store name, phone, fax, email for each store.  Each store has a postal address containing street address, city, state and postcode. 
  • Each store has a number of departments, for example, finance, accounts, sales, customer service etc. For each department, there is a department ID, department name, phone and e-mail address.
  • Each department has a number of employees. For each employee, BigM keeps a record of their employee ID, first name, last name, phone, date of birth, start date of his/her work and tax file number. 
  • BigM also stores postal and residential addresses of their employees. For each address they need to store street address, city, state and postcode.
  • An employee can be employed as casual or fulltime basis. For a casual staff, his or her job type (for example, accountant, sales, customer service etc.), and hourly rate is recorded. For a fulltime staff, his or her job type and annual salary is recorded.
  • Each store is managed by an employee as a store manager and each department is supervised by an employee. The department supervisor is also the supervisor for all the staffs within that department.
  • Each store may be assigned a supervising store where all training, payroll, server application and help desk are located.
  • Each supervising store generates pay slips for all staffs (in this store and other stores being supervised) on a fortnightly basis. For each pay slip, the store records a pay ID, supervising store ID, employee ID, pay date, number of hours and the gross payment.
  • BigM sales different products like CDs, cloths, computers etc. For each CD it keeps a record of CD number, title, length, number of tracks, release date, category description, price and reorder level. 
  • BigM would like to maintain information for each artist in the CD. They would like to include first name, last name and date of birth and website address, if they have one. If possible, BigM also wants to store number of tracks where a particular artist appears in a given CD. 
  • For cloths and other products it stores product number, product description, brand, product size and price.
  • An inventory of the number of each particular product in each store is kept. BigM keeps track of


the quantity of each product that is on order, as well as the number currently available in each store.

  • Customer may place orders in the store. Customer details are always taken at each order.  A customer is referenced by a customer number, customer first & last names, phone number and postal address, if available. For each address they need to store street address, city, state and postcode. 
  • A customer may order more than one product at a time, and they may order multiple copies of the same product. BigM also records the date a product arrives and the date when it is picked up by the customer. Note that these dates may be different for each product.
  • BigM understands that they may not have provided you with sufficient information.  If you need to make assumptions about their organisation please ensure that you record them.


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 file is to be submitted within lectures.


The design document should contain:


  1. A completed copy of 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 entity relation (E-R) diagram that models the problem which includes:
    1. all entities, relationships (including names) and attributes;
    2. primary (underlined) and foreign (italic) keys identified;
    3. cardinality and participation (optional / mandatory) symbols; and
    4. 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’s feet).


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


  1. Relational data structures that translate your E-R diagram which includes:
    1. relation (table) names, 
    2. attribute (column ) names and field types (as required by WAMP),
    3. primary and foreign keys identified; 

The data structures should be shown using the standards of this course.


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



Assessment Criteria



  1. How clear and well-presented your submission is.
  2. E-R diagram: adherence to our standard, assumptions made, inclusion of correct primary


and foreign keys, appropriate entities, relationships, and attributes.

  1. Normalisation: appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal.
  2. Conversion of E-R diagram to relational schema: schema is a correct translation of the E-R submitted with appropriate tables, columns, and primary keys.






Assignment 1 – Marking Overview



ER Diagram


/ 50

Relational Structure






Relational Schema










Unlock Better Papers
Pages (550 words)
Approximate price: -

Why Hire a Professional Essay Writer from essayprohire

The quality of an essay is important

If you want to be successful in the essay writing world, it’s important to make sure that the quality of your work is high. A professional essay writer from us will be able to provide you with high-quality papers, and they will also have the experience necessary to write effective essays. This means that you won’t have to worry about any errors or problems with your essays – they will be perfect.

Our Customer service is top-notch

If you have a problem with your essay, or if you just need a little help writing it, then you should contact our customer service. Our customer service is always available to help you with whatever you need – from getting your essay correct to helping you with the grammar and punctuation. We’re here to help, so don’t hesitate to call us today!

Our offer on Unlimited Revisions

If you're looking for essaywriting help, then you should definitely consider getting help from a essaywritinghelpnow. However, if you're not sure what you need or whether you have the time or resources to do the research yourself, then you might want to consider getting unlimited revisions done by our team of experts. O

Our guarantee to Confidentiality

We understand the importance of confidentiality, and we will never share your personal information with anyone without your permission. That’s why we offer a one-year guarantee that your essays will remain confidential. If you decide that you no longer want us to write your essays, we will still respect your privacy and will destroy all the evidence that we had of your work.

Our Reliability

We believe that it is important to have a reliable and trustworthy essaywriter. That’s why we offer a 100% satisfaction guarantee on all of our essays. We take the time to get to know our clients, and we will always make sure that our essays are of the highest quality. We understand that not everyone is happy with their first essay, so we want to make sure that you’re always satisfied with the results of our work.

Our punctuality and quality

At our company, we pride ourselves on our punctuality and quality. We understand that it can be difficult to get essays written on time, and we’re here to help you out! Our writers are always available to help you with your essay, and we guarantee that you’ll receive the best possible product. We also have a strict no-nonsense policy when it comes to plagiarism, so you can be sure that your essay will be of the highest quality.


Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.


Our Services

So much stress and so little time? Take care of yourself: let us help you with your tasks. We offer all kinds of writing services.


Custom Essay Writing Services

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.


Admission and Business Papers

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.


Editing and Proofreading

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.


Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.