Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Assignment 1 Development of an ER Diagram and Database Implementation

Course Objectives:

This assessment task focuses on the following course objective:
• use entity-relationship diagrams to design a relational database.

Project Specification

You have been commissioned by Julie from ABC Event Organisers to design the database to assist them with managing their booking, customer and supplier information. You are only required 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 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 offer 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 offer furniture like chairs, tables, or other items such as table clothes, cutlery and crockery. Suppliers may only offer one product or many different products. ABC will like to be able to search their database to get a list of suppliers who supply particular products, though, they don’t required 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 casual basis. ABC require 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 might hold the number of various skills and certifications. Some staff is supervisors of other staff members and this also requires being stored.

For each 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 christenings, weddings, birthday parties and work functions. For each event they require to store information about the supplies which they need (like tables, chairs, sets of cutlery), the supplier which they will be using for the various products (they could 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 might not have offered you with enough information. If you require to make assumptions about their organisation please make sure that you record these.

The design document must contain:

1. An appropriate title page which includes an acknowledgement of all students you have spoken to about the assignment.

2. A table of contents and automatically generated page numbers.

3. An entity relation diagram which models the problem that 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, like how you arrived at cardinality / participation for those not mentioned or clear in the business description, etc.

e.The E-R must be completed using standards of this course

4. Relational data structures which translate the 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.

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

a. table names,

b. column names and field types

c. primary and foreign keys identified

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

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

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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