Hire Expertsminds Qualified and Experienced Tutor Data Modelling Technique Assignment Help Service!!

Home   Course  
Previous << || >> Next

MN405 Data and Information Management Assignment - Data Model Development and Implementation, Melbourne Institute of Technology, Australia

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.

ORDER NEW MN405 DATA AND INFORMATION MANAGEMENT ASSIGNMENT AT NOMINAL PRICE!

1. Complete the information-level design for a database.

a. Identify and list entities described in all user requirements given above.

b. Add attributes to these entities and represent them as a collection of tables and attributes.

c. Outline 3 business rules that describe the relationships between entities.

d. Determine the functional dependences.

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

Information Requirements

Identify all entities

Entitles are shown below:

Category

Exercise

Customer

Program

Coach

User Views as Tables

Exercise (ExcerciseID, Date, Category, Sub_category,Time_Spent,calorieBrunt)

Customer (CustomerID,CustomerFirstName,CustLastName,Address, Program)

Program (Pnum,ProgramTitle,StartDate,FinishDate,Price, Coach, Exercise)

Coach (CoachID,FirstName,LastName,DOB.Address,ContactNo,Username,Password)

ORDER NEW COPY OF DATA MODELLING TECHNIQUE ASSIGNMENT & GET HIGH QUALITY SOLUTIONS FROM SUBJECT'S TUTORS!

Relationships

Each program can have one to many Exercise

A Coach can work on only one program.

A customer can enrol in one or many program

Functional dependences.

ExcerciseID → Date, Category, Sub_category,Time_Spent,calorieBrunt

CustomerID → CustomerFirstName,CustLastName,Address, Pnum

Pnum → ProgramTitle,StartDate,FinishDate,Price, ExcerciseID

CoachID → FirstName,LastName,DOB.Address,ContactNo,Username,Password, Pnum

Normalize tables

ExcerciseID → Date, Category, Sub_category,Time_Spent,calorieBrunt

CustomerID → CustomerFirstName,CustLastName,Address

Pnum → ProgramTitle,StartDate,FinishDate,Price

CoachID → FirstName,LastName,DOB.Address,ContactNo,Username,Password

ProgramCoachID → Pnum,Coach

ProgramTakenID → Program,Customer

ProgramExcerciseID → PNum,Exercise

SAVE TOP GRADE USING DATA MODELLING TECHNIQUE ASSIGNMENT HELP SERVICE OF EXPERTSMINDS.COM

2. Represent the structure of your database visually by using an entity-relationship (E-R) diagram. If you make any assumptions about data that are not explicitly given in the problem, these must be described.

ER Diagram

Data Modelling Technique.png

DO YOU WANT TO EXCEL IN DATA MODELLING TECHNIQUE ASSIGNMENT - ORDER AT EXPERTSMINDS!

3. Build this model using MS Access/ SQLite by creating these tables and Relationships. Populate these tables with appropriate data; include at least 2 records in each table. Include the following in your MS Word document.

Model building

Deepanshu_Exercise

Design View

Data Modelling Technique1.png

Data view:

Data Modelling Technique2.png

Deepanshu_Customer

Design View

Data Modelling Technique3.png

Data View

Data Modelling Technique4.png

Deepanshu_Program

Design View

Data Modelling Technique5.png

Data View:

Data Modelling Technique6.png

Deepanshu_Coach

Data Modelling Technique7.png

Data View

DON'T MISS YOUR CHANCE TO EXCEL IN DATA MODELLING TECHNIQUE ASSIGNMENT! HIRE TUTOR OF EXPERTSMINDS.COM FOR PERFECTLY WRITTEN DATA MODELLING TECHNIQUE ASSIGNMENT SOLUTIONS!

Data Modelling Technique8.png

Deepanshu_ProgramCoach

Design View

Data Modelling Technique9.png

Data View

Data Modelling Technique10.png

Deepanshu_ ProgramTaken

Design View

Data Modelling Technique11.png

Data View

Data Modelling Technique12.png

Deepanshu_ProgramExcercise

Design View:

Data Modelling Technique13.png

Data View:

Data Modelling Technique14.png

WORK TOGETHER WITH EXPERTSMIND'S TUTOR TO ACHIEVE SUCCESS IN DATA MODELLING TECHNIQUE ASSIGNMENT!

4. Report Generation

a. Write an SQL query to generate one example of useful information that can be obtained from this database.

b. For additional 5 marks you will execute more queries (at least 2) on the table join from the database you created in Question 3 and include the screen shots of the outputs and all SQL statements.

Report Generation

Query 1

Data Modelling Technique15.png

Query 2

Data Modelling Technique16.png

GET BENEFITTED WITH QUALITY MN405 DATA AND INFORMATION MANAGEMENT ASSIGNMENT HELP SERVICE OF EXPERTSMINDS.COM!

Access our Melbourne Institute of Technology, Australia Assignment Help Services for its related units such as:-

  • MN501 Network Management in Organisations Assignment Help
  • MN502 Overview of Network Security Assignment Help
  • MN503 Overview of Internetworking Assignment Help
  • MN504 Networked Application Management Assignment Help
  • MN506 System Management Assignment Help
  • MN601 Network Project Management Assignment Help
  • MN603 Wireless Networks and Security Assignment Help
  • MN621 Advanced network Design Assignment Help
  • MN691 Research Methods and Project Design Assignment Help
  • MN692 Capstone Project Assignment Help
  • MN404 Fundamentals of Operating Systems and Programming Assignment Help
Tag This :- EM1915DEE2605OTH Data Modelling Technique Assignment Help

get assignment Quote

Assignment Samples

    Fences by August Wilson Assignment Help

    fences by august wilson assignment help - The essay is based on the story of Fences by August Wilson that focused upon the conflicts that arises among Troy Maxs

    PEST Analysis Assignment Help

    pest analysis assignment help - Present the result of your assessment in a PEST Analysis Grid and a textual explanation

    Advocacy for Change Assignment Help

    advocacy for change assignment help - When we compare the treatments of African Americans and white Americans we can see that African American was treated

Get Academic Excellence with Best Skilled Tutor! Order Assignment Now! Submit Assignment