$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 / 296 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)

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/organizer-information.html.

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

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

My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2020 [cited 23 July 2021]. Available from: https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/organizer-information.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

MBA503 Final Project Guidelines And Rubric

Download : 0 | Pages : 4

Answer: Milestone three: Financial statement of the company is prepared to evaluate the financial performance as well as financial position during the accounting period. In order to prepare the financial statement companies are required to follow the requirements of accounting principles and standards as per “generally accepted accounting principles (GAAP)”. As per the regulations provided under GAAP, companies are required to pr...

Read More arrow Tags: United States Mcdonough Management MBA 503 Final Project Guidelines and Rubric  Southern New Hampshire University MBA 503 Final Project Guid 

HOS203A Food And Beverage Management

Download : 0 | Pages : 6

Answer: Introduction The use of social enterprises is a new idea that consumers currently need to adapt to. Looking into the case provided by the consultants, we are engulfed in the situation of Sally Irwin who happens to have been working in the social enterprise space for a long time. Even though the level of her expertise alongside professional experience has been the key towards her rise to a senior position in the same field, it is her p...

Read More arrow Tags: Australia Blacktown Management University of New South Wales Masters in Business Administration 

Y508 Human Resource Management

Download : 0 | Pages : 5

Answer: Introduction The aim of this report is appreciating and applying the principles present in effective Human Resource Management (HRM). The lifeblood of any organization are its people and the ability of attracting, recruiting and retaining talented staff as a core of all HR activities. This report would be exploring the techniques and tools that are used in HRM for maximizing the employee contributions and the ways of using HR methods ...

Read More arrow

BPS 6311 Strategy Implementation

Download : 0 | Pages : 4

Answer: Internal Environment Internal Structure Google effectiveness and success is linked to the cultural up gradation and organizational reformation of the structure. The company structure is not conventional and this is the reason direct social link cannot affect the internal programs as well. On the other hand, the business expansion of the company creates higher chances of success. Google has maintained a cross-functional organization ...

Read More arrow Tags: United States New York Management Economics University of New South Wales 

MGMT 350 Business Management Internship

Download : 0 | Pages : 8

Answer: 1. Chick-fil-A: their business philosophy and corporate strategy The history of Chick-fil-A dates back to as early as 1946. At present, it is the second-largest chicken eatery in the United States of America. It was initially started as a restaurant named Dwarf House and now has over 1700 outlets in the United States alone. Their business philosophy is that of giving –– they believe that at their company, everybody&rs...

Read More arrow Tags: Australia Belleville Management Corporate Business Philosophy University of Sydney MBA 
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?