Complete the information-level design of the database

Assignment Help Computer Networking
Reference no: EM131992125 , Length:

Data and Information Management - Data model development and implementation

Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain understanding of data model development. Then implement the data model using a commercially available database management system development tool.

On completion of this assignment students will be able to:
a. Understand the fundamental principles of the networking and data requirements of a network.
b. Identify organisational information requirements.
c. Model organisational information requirements using conceptual data modelling techniques.
d. Convert the conceptual data models into relational data models and verify their structural characteristics with normalisation techniques.
e. Implement and utilise a relational database using a database system.

Assignment Description

1. 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) to1(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 workshopswhich 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. Meetingsrooms are identified by a floor and room number.
- Every workshop needs an allocated meeting room; where a workshop lasts for two days, it willuse the same room on both days

Questions:

a. Analyse the all user requirements given above, identify and list all entities described in each user requirement.

b. Add attributes to these entities and representthese entities (or Tables) and attributesas a collection of Tables and attributes/ database schema. You are required to arrange them as given in the example below.

Note:Select suitable primary key for each table and underlineit.

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

c. Outline all business rules that describe relationships between entities.

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

d. Determine the functional dependences.

Eg. Participant_ID → name, address, ......

e. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.

f. 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: Youare required to use Visio or any other software tool to create the ER diagram.

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

3. Write SQL queries for the following questions and execute themon 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 Accessby creating these tables and Relationships. Populate these tables with appropriate data, at least 3 records in each table.

a. List details of all workshops.

b. The management is interested in knowing names and email addressesof participantsoutside of Victoria who have already registered for the workshops.

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

Verified Expert

The solution file is prepared in ms access and word which has table names and each table attributes and relationship. The report has functional dependency and relationship diagram with required queries and ER diagram for case study. References are included as per IEEE format.

Reference no: EM131992125

Questions Cloud

Complete ratio analysis for the last fiscal year : Complete ratio analysis for the last fiscal year using at least two ratios from each of the following categories: Liquidity.
Rejection region for the f-test and the test statistic : Also, calculate the critical F-value,the rejection region for the f-test, and the test statistic.
Could a company show a profit and still be short of cash : Current assets and current liabilities are extremely important to any business. As assets and liabilities with a short-term duration.
Describe the arbitrage opportunity open to trader : Using put-call parity, identify - and describe - the arbitrage opportunity open to a trader.
Complete the information-level design of the database : MN405 - Data and Information Management - Data model development and implementation - Analyse the all user requirements given above, identify
Binomial trees and american options : What is the value of a six-month European put option with a strike price of $42?
Analyze the complexities of the derivative markets : Analyze the complexities of the derivative markets and how the reporting of derivatives may be deceiving to investors.
The current yield of the bond : Consider a 22-year bond with 8 percent annual coupon payments. The market rate (YTM) is 5.4 percent for this bond.
Describe the company and identify the division you manage : Discuss the most appropriate method for allocating the manufacturing overhead. How would different allocation methods affect the bottom line for your division?

Reviews

len1992125

5/22/2018 5:46:21 AM

2. Model building Extremely good effort. All elements are present Good effort. Most components are present Good effort made but some components are missing Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies 3.Implement and utilise a relational database using a database system- SQL queries All elements are present and very well integrated, Logic is very clear and easy to follow Components present and well integrated, Logic is clear Components present and mostly well integrated, Logic is mostly consistent Most components present, logic is not clear and consistent Representation lacks structure. Arguments are confused and disjointed

len1992125

5/22/2018 5:46:15 AM

f. ER Diagram - Model organisational information requirements using conceptual data modelling techniques Extremely good effort. All elements are present and very well integrated. Outstanding Good effort. Most components are present and well integrated Good effort made but not outstanding Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies

len1992125

5/22/2018 5:46:08 AM

Grade Mark HD 100% DISTINCTION 80% CREDIT 60% PASS 40% Fail 0-40% 1.(a),(b)(c) Identify organisational information requirements- Ability to think critically and analysed clearly Relevant and soundly analysed. Generally relevant and analysed. Some relevance and briefly presented. Not relevant to the assignment question. 1(d)(e) Funcional dependencies and normalisation - Convert the conceptual data models into relational data models and verify their structural characteristics with normalisation techniques. Demonstrated excellent ability to think critically and identifieddependencies correctly Demonstrated good ability to think critically and identified dependencies correctly. Demonstrated ability to think critically and identify some dependencies. Demonstrated some ability to think critically identify some dependencies. Did not demonstrate ability to think critically

len1992125

5/22/2018 5:45:59 AM

Please make sure you guys read the whole document of this assignment and follow all the instructions.Format should be correct and IEEE reference should be there. Assignment should be plagiarism free.please make it best assignment. Thank you. Marking criteria: Example of marking criteria is shown in the following table. Marks are allocated as follows: Section to be included in the report Description of the section Marks 1. a. identify all entities Identify entities in all user requirements 5 b. User Views as Tables Represent the User Views as a collection of Tables 5 c. Relationships Determine the relationships between entities 5 d. Functional dependences. DetermineFunctional dependences. 5 e. Normalise tables Analyse above tables and normalise 5 f. ER Diagram Represent the structure of your database visually by using the ER diagram.Evaluate your proposed solutions 15 2. Model building Model building on MS Access Server 10 3. Implement and utilise a relational database using a database system 10 TOTAL marks or the Report 60

Write a Review

Computer Networking Questions & Answers

  Networking and types of networking

This assignment explains the networking features, different kinds of networks and also how they are arranged.

  National and Global economic environment and ICICI Bank

While working in an economy, it has a separate identity but cannot operate insolently.

  Ssh or openssh server services

Write about SSH or OpenSSH server services discussion questions

  Network simulation

Network simulation on Hierarchical Network Rerouting against wormhole attacks

  Small internet works

Prepare a network simulation

  Solidify the concepts of client/server computing

One-way to solidify the concepts of client/server computing and interprocess communication is to develop the requirements for a computer game which plays "Rock, Paper, Scissors" using these techniques.

  Identify the various costs associated with the deployment

Identify the various costs associated with the deployment, operation and maintenance of a mobile-access system. Identify the benefits to the various categories of user, arising from the addition of a mobile-access facility.

  Describe how the modern view of customer service

Describe how the greater reach of telecommunication networks today affects the security of resources which an organisation provides for its employees and customers.

  Technology in improving the relationship building process

Discuss the role of Technology in improving the relationship building process Do you think that the setting of a PR department may be helpful for the ISP provider? Why?

  Remote access networks and vpns

safekeeping posture of enterprise (venture) wired and wireless LANs (WLANs), steps listed in OWASP, Securing User Services, IPV4 ip address, IPV6 address format, V4 address, VPN, Deploying Voice over IP, Remote Management of Applications and Ser..

  Dns

problems of IPV, DNS server software, TCP SYN attack, Ping of Death, Land attack, Teardrop attack, Smurf attack, Fraggle attack

  Outline the difference between an intranet and an extranet

Outline the difference between an intranet and an extranet A programmer is trying to produce an applet with the display shown in Figure 1 below such that whenever one of the checkboxes is selected the label changes to indicate correctly what has..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd