Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Objectives:

This assessment task focuses on the following course objective:

• Utilize entity-relationship diagrams to design the relational database.

Project Specification

You have been commissioned by Julie from ABC Event Organisers to design a database to assist them with managing their booking, customer and supplier information. You are only need to provide the design of the database at this time.

ABC will like to store information regarding their customers. Customers might either be individual or corporate customers. For individual customers they will like to store the contact name, address details (including their location, postal and delivery address details), email address and phone numbers (mobile, home, work). For their corporate customers they will like to store the business name, a contact name, address details (including their location, postal and delivery address details), email address, website URL, and phone numbers (mobile, work).

ABC has a number of different suppliers who provide them with the products which they need to organise events. For each supplier they will like to store their business name, contact name, address details (including their location, postal and delivery address details), and phone numbers (mobile, work).

Each supplier might provide a number of different products. Like a supplier may provide furniture such as chairs, tables, or other items such as table clothes, cutlery and crockery. Suppliers may only provide one product or many different products. ABC would like to be able to search their database to obtain a list of suppliers who supply particular products, however, they do not need to know how many of each particular product the supplier stocks.

In the database ABC will also like to store information about their staff. Staff might be employed full-time, part-time or on a casual basis. ABC required to store contact information for the staff (address and phone), along with their TFN. They will also like to know what certifications the employees have. Like: “Responsible Serving of Alcohol”, “Food Handling”, or any related police checks like “Working with Children”. Each employee may hold a number of different skills and certifications. Some staff is supervisors of other staff members and this also needs to be stored.

For every event ABC will like to store details like where the event is to be held, the customer who they are organising the event for, the date and time of the event, the type of event and how many people will be at the event. ABC specialises in organising weddings, christenings, birthday parties and work functions. For each event they require to store information about the supplies that they require (eg tables, chairs, sets of cutlery), the supplier that they will be using for the different products (they can use more than one), and how many of each product they require. ABC will also like to store details of the staff that have been assigned to each event. Each event will have one staff member who takes on the role of event manager.

ABC 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 these.

You must produce a single pdf file, created using Word, containing all of the requirements as specified within this document

The design document should contain:

1. A completed copy of the SITE Assignment Coversheet.

2. A suitable title page which 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 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 must be completed using the standards of this course (crow’s feet).

5. Relational data structures that translates your E-R diagram which includes:

a. relation names;

b. attribute names;

c. primary and foreign keys identified; and

d. for each relation the level of Normalisation achieved, and for any not to Third Normal Form, describe why.

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

6. A relational database schema that translates your relational data structures that includes:

a. table names,

b. column names and field types

c. primary and foreign keys identified

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

Your assignment must be completed according to the University of Ballarat General Guide for the Presentation of Academic Work. This is available online at the following web address:

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

Guidelines:

1. E-R diagram: adherence to our standard, assumptions made inclusion of correct primary and foreign keys, appropriate entities, relationships, and attributes.

2. Normalisation: appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal.

3. 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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91498

Have any Question? 


Related Questions in DBMS

Here is two assignment one is only summery of project from

Here is two assignment one is only summery of project from first assignment, in powerpoint. pleasedont copy and paste, it will be verified by software for plagiarism. please cite all sources by APA format. due date is 26 ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

This assignment consists of two 2 sections a design

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name accor ...

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

Assignmentconsider the employee database with the following

Assignment Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. The list of tables is: Company(cid, company_name, city, state) /* city ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start­up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

1 draw and explain erm diagram andnbsp explain what is

1. Draw and explain ERM diagram and  explain what is REM 2. Explain what is Normalization . what is 0NF,1NF, 2NFand ,3NF and explain what is in the tables Entity Relationship Modeling and Normalization: 1 System Analysis ...

Listed the five important software components of a dbms the

Listed the five important software components of a DBMS: the DBMS engine, the data definition, data manipulation, application generation, and data administration subsystems. Which of those are most and least important to ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen