Question: PART A (10 MARKS) As a database designer, you need to develop a clean eating diet plan database system based on the following requirements:

PART A (10 MARKS) As a database designer, you need to develop a clean eating diet plan database system based on the following requirements: 1. Open Microsoft Access and create a blank Access database. Save as: "YourFullName_StudentID_Clean Diet DatabaseSystem" ANSWER: (2 marks) Paste your screenshot of database here 2. Create tables as listed below and choose appropriate data types for each attribute. Then create the relationship between tables. You also need to insert 5 records (sample data) per table. PROFILE (UserID, Name, Gender, Height, Weight, Age, Lifestyle, Goal) FOOD (FoodID, FoodName, ServingSize, Calories, FoodType) FOODLOG (LogID, LogDate, Meal, NumberOfServing, FoodID, UserID) *Data for Lifestyle in table PROFILE is sedentary/active *Data for FoodType in table FOOD is fruits / vegetables / snacks/protein/carbohydrate *Data for Meal in table FOODLOG is breakfast / lunch/dinner ANSWER: Paste your screenshot of output here (8 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Estimate the functional values and the limits from the graph of the function f provided in Figure 14. y -5-4-3-2-1 If the answer does not exist, enter DNE. lim f(x)= #12 lim f(x)= 2-2+ lim f (x) =...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

After your initial investigation, the following user requirements were to be highlighted: 1 . Identify the different types of users who might access the Database Management System ( DBMS ) for...

I need help answering question 2-3-4-5 with an explanation. I am not being able to answer them! 10 56% CANADIAN DATA SYSTEMS, Ltd. Canadian Duta Systems (CDS) is one of Canada's largest manufacturers...

Page 1 of 4 SQL Assignment ACCTG 333 - Fall 2019 Professor Perols Due Friday, November 8, 2019 Why should you learn SQL? Technology is drastically changing the accounting industry...and structured...

Create a General System Design (system architecture, network model, etc. ) for company BrandSafeWay using the following items please! Cloud Database: Database Platform: Utilize a reliable cloud-based...

CCC Background James Pantin always took pride in his appearance. He believed that a well-pressed suit was the key to good day. In 1998 he had the opportunity to purchase a small dry cleaning company...

Show the parse trees for the two parses that the grammar assigns for sentence S1. S1: the train station bus rumbles [3 marks] (b) Give an algorithm for a bottom-up passive chart parser without...

Case Study 1 Group Work Assignment 2 45 total marks Group Contract Part 1 10 Marks 1. Develop a group contract and team agreement as outlined and using the templates 2. Outline acceptable behavior...

Which of the following is the least likely reason for acquisition? To analyze a strategic resources gap O To access new capabilities or competencies O To preempt rivals O To access new markets and...

Criticize two business ideas from the Shark Tank program, with detailson each strength and weakness and the element or elementsthat result in the presentation's success or failure, in your opinion....

The business school faculty has become increasingly concerned about the ethics associated with modern business practice. The general reputation of business executives is in the tank. They are seen as...

Binomial parameters for two groups are graphed, with 1 on the horizontal axis and 2 on the vertical axis. Plot the locus of points for a 2 2 table having (a) relative risk = 0.5, (b) odds ratio =...

Reflection high-energy electron diffraction (RHEED) has become a commonplace technique for probing the atomic surface structures of materials. Under vacuum conditions an electron beam is made to...

The following profit reconciliation statement summarizes the performance of one of SEWs products for March.............................................................(?)Budgeted profit..............

The members of the class are the employees of a small, privately held company that produces computer games. Everyone shares in the profits of the company. The company has been making electronic...

At the end of the school year, you hire the best students to write comprehensive study guides for the classes they have just completed. Over the summer you then compile these guides, print them out,...

your father is about to retire and he wants to buy an annuity that will provide him with 7 8 0 0 0 of income a year for 2 5 years with the first payment coming immediatly the going rate on such...

Using Rocky Mountain Outfitters and the customer support subsystem as your guide, develop a list of all the procedures that may need to be researched. You may want to think about the exercise in the...

Explain how iterative development makes project scheduling more complex.

1. Assume that system users and owners have indicated a strong desire for a system that can be accessed anytime, anywhere. Discuss the implications of their desire for the system scope. Given the...

Under what circumstances would a taxpayer who generates a loss from renting a home that is not a residence be able to fully deduct the loss? What potential limitations apply?

Several years ago, Junior acquired a home that he vacationed in part of the time and rented out part of the time. During the current year Junior: Personally stayed in the home for 22 days. Rented...

A taxpayer owns a home in Salt Lake City, Utah and a second home in St. George, Utah. How does the taxpayer determine which home her principal residence is for tax purposes?