Complete the information-level design for a database that satisfies the following constraints and user view requirements.

Who We Are

We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.

Do you handle any type of coursework?

Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.

Is it hard to Place an Order?

1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.

2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.

3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.

4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.

5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

Need help with this assignment?

Order it here claim 15% discount

Discount Code: SAVE15

Order Now Free Inquiry

We got you covered for the whole semester.

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.Questions:1. Complete the information-level design for a database that satisfies the following constraints and user view requirements. In order to complete this information–level design you are required to answer the questions given below 1(a) – (e).Mindful Body Fitness Company is planning to design a data model to hold information relating to their programs, coaches, exercise logs and their customers. As a database designer for Mindful Body Fitness, you need to ensure that each Exercise Log has a unique ID number, Date, Exercise category, Exercise sub category, Time spent, calories burnt.Each customer has a unique Cust_number and their first name, last name, address, program number, program tile and Payment must be recorded.Every program has a program number (PNum) that uniquely identifies the program. The program title, StartDate, Finish Date, Price must also be recorded.Each coach has a unique ID number. Their first name, last name, date of birth, address, contactNo, user name and password must be recorded.A coach can work on only one program. A program can have one or more coaches associated with it. One customer can enrol for only one program at one time.Write down any assumptions you make, if they are not explicitly described here.a. Identify and list entities described in all user requirements given above. (5 Marks)b. Add attributes to these entities and represent them as a collection of tables and attributes (Database schema): e.g. Customer (Customer_Num, Cust_First_Name,. . . . . . )Note: Select and underline suitable primary key for each table. (5 Marks)c. Outline 3 business rules that describe the 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.e.g. A Coach can work on only one program.d. Determine the functional dependences. (5 Marks)e.g. Customer_Num ? Cust_First_Name e. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.

Hello, this question is here because we've worked on this and other similar assignments. If you don't know the answer, you can ask us for help. We guarantee an original paper free from Plagiarism.

Order a Similar Paper Order Different Paper

We got you covered for the whole semester.