fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

MN405 Data And Information Management

tag 0 Download2 Pages / 351 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

The organisers of the GreenID2018 international multi-conference need to keep track of a large collection of workshops associated with the event. Initial requirements analysis brings out the following User view requirements / business rules about what needs to be recorded. Assume that you are given a task to model the database by using these business rules. 

Complete the information-level design of the database that satisfies the following constraints and user view requirements. In order to complete this information-level design you are required to answer questions 1(a) to 1(f).

User view 1 requirement  / business rule

  • There are several participants, each of which may sign up to one or more workshops. 

      User view 2 requirement  / business rule

  • Each workshop has a name, ID and an identified organizer .
  • Some workshops happen on a particular date and some workshops last more than one day. You may need separate entity to store days. 

User view 3 requirement  / business rule

  • For each participant, it is important to record their name, email address, state (VIC, QLD,..) and the workshops which they wish to attend.
  • Every participant must register for at least one workshop.

User view 4 requirement / business rule

  • There are a number of meeting rooms at the conference venue, each of a fixed capacity. Meetings rooms are identified by a floor and room number.
  • Every workshop needs an allocated meeting room; where a workshop lasts for two days, it will use the same room on both days 

Questions:

  1. Analyse the all user requirements given above, identify and list all entities described in each user requirement.                                                                                                                                            (5 Marks)
  2. Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes/ database schema. You are required to arrange them as given in the example below. (5 Marks)

Note: Select suitable primary key for each table and underline it.

Eg.        Participant (Participant_ID, P_name, email, W_name.) 

  1. Outline all business rules that describe relationships between entities. (5 Marks)

Note: You can make assumptions to create certain relationships, if it is not specifically mentioned in the given business rules.

Eg.          Every workshop needs an allocated meeting room

  1. Determine the functional dependences.                                                                                       (5 Marks)

Eg.  Participant_ID  à name, address,  ...... 

  1. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.  (5 Marks)
  1. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that doesn’t show from the problem, they must be described.

Note: You are required to use Visio or any other software tool to create the ER diagram.  (15 Marks) 

  1. Build this model using MS Access by creating these tables and Relationships. Populate these tables with appropriate data, at least 3 records in each table. (10 Marks) 
  1. Write SQL queries for the following questions and execute them on the database you created in Question 4.

 Include screen shots of the outputs and all SQL statements you used to answer following questions this model using MS Access by creating these tables and Relationships.   Populate these tables with appropriate data, at least 3 records in each table.

  1. List details of all workshops.  (3 Marks)
  1. The management is interested in knowing names and email addresses of participants outside of Victoria who have already registered for the workshops. (3 Marks)
  1. Explain how to formulate a query to print details of workshop name, room number, floor number and room capacity

Hint : You need to  join tables using a suitable query.  (4 Marks)

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Data And Information Management. Retrieved from https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/database-entities.html.

My Assignment Help (2020) Data And Information Management [Online]. Available from: https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/database-entities.html
[Accessed 18 October 2021].

My Assignment Help. 'Data And Information Management' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/database-entities.html> accessed 18 October 2021.

My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2020 [cited 18 October 2021]. Available from: https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/database-entities.html.


MyAssignmenthelp.com delivers assignment help to millions of students of USA. We have in-house teams of assignment writers who are experts on wide ranges of subjects. We have appointed teams of native writers who provide assignment help to students in New York City and all over the USA. They are skilled assignment writers who successfully cater to search terms like do my assignment in the USA

Latest Management Samples

101557 The Individual In Society

Download : 0 | Pages : 11

Answer: Introduction In learning journal 1 author of the study stated that there no thing exist which is meaningless, everything is revealing some meaning which individuals mind needs to be perceived in their own way of perception. The learning reflection summarized as follows that the first part is explaining about the learning behavior of an individual that a process of learning acquires a proper perception of behavior and psychology that n...

Read More arrow

IENG 6990 Directed Studies In Industrial Engineering

Download : 0 | Pages : 4

Answer: Introduction The Wind Turbine project is for a small grid connected household wind turbine. The wind turbine is expected to provide 5 KW of electricity / per year to the household/farm. The turbine will store electricity in an inverter and hence, the product will have two versions. The inverter will be sourced independently as is not a part of the turbine building process. Bill of Materials (BOMS) Bill of Materials , generally, incl...

Read More arrow Tags: United States Charlottetown Management Program Planning and evaluation in Public Health University of Virginia 

BUMGT6935 Operations Management

Download : 0 | Pages : 12

Answer: Introduction: The following report is going to analyse the operations management of Big W Australia. Operations management, according to Krajewski, Ritzman & Malhotra (2013), is one of the major areas of management study and approach that constitutes the entire process of a business. As a matter of fact, the entire process of the production, product design and the supply, customer service management and other sectors of the entire...

Read More arrow

BUS499 Principles Of Economics

Download : 0 | Pages : 7

Answers:  A ceiling of price happens at a time when a state puts in action a legal limit the height the price should reach for a given product. For an effective price ceiling, the latter should be set right beneath market equilibrium. A shortage arises automatically as soon as a price ceiling is set. There is more demand occurring than it should be at equilibrium price when a price ceiling is set. The supply also goes down when there is pri...

Read More arrow

CIS8004 Enterprise Planning And Implementation

Download : 0 | Pages : 3

Answers: Answer 1: The Enterprise Architecture has an important role to an organization for having several advantages. Generally, individual decisions in an organization can address the issues of a business in their vicinity. However, enterprise architecture can have holistic point of view as well as work for identifying the issues around the organization. In addition, enterprise architecture helps in providing consistent delivering solutions...

Read More arrow Tags: Australia Lakemba Management web media University of New South Wales Masters in Business Administration 
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?