Ask Question, Ask an Expert


Ask DBMS Expert

Home >> DBMS


Task 1 Initial Design

problem 1: Generate an entity relationship model for the proposed database system for Apply by Events Management. This must be a fully normalised model to third normal form. You don’t have to show the steps you took in the normalisation process.

problem 2: Generate a data dictionary for the entity relationship model.

Task 2 Data and Queries

problem 3: Create all the tables using SQL. Show your Create scripts and the finished tables.

problem 4: Add data on all the Events listed in the assignment. Note that the client ‘Lord Eaglestone’ has commissioned more than one Event. Give a listing of this.

problem 5: Add data for five Events and their associated venues. Give a listing of this.

problem 6: Add data on equipment and suppliers and the Events they are assigned to. Give a listing of this.

problem 7: prepare a query that selects all Events of a particular type with all the speakers assigned to each Event.

problem 8: prepare a query whcih selects the equipment and venues for each event.

Task 3 Evaluation

problem 9: Give an assessment of how the work you have done has met the requirements of the firm.


i) The word-processed report should be 1250 words.

ii) Familiarise yourself with the NCC Education Academic Dishonesty and Plagiarism Policy and make sure that you acknowledge all the sources which you use in your work.

iii) All citations and references should use the Harvard Style

iv) You should submit a paper copy and digital copy.

v) Media containing viruses, or media that can’t be run directly, will result in a fail grade being awarded for this module.

DBMS, Programming

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

Have any Question? 

Related Questions in DBMS

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

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

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Assignmentyou are to design a program that will serve as a

Assignment You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its gen ...

Assignment database modeling and normalizationimagine that

Assignment: Database Modeling and Normalization Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solution ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

  • 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