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
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 view:
Deepanshu_Customer
Design View
Data View
Deepanshu_Program
Design View
Data View:
Deepanshu_Coach
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!
Deepanshu_ProgramCoach
Design View
Data View
Deepanshu_ ProgramTaken
Design View
Data View
Deepanshu_ProgramExcercise
Design View:
Data View:
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
Query 2
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