PART A (10 MARKS) As a database designer, you need to develop a clean eating diet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Systems analysis and design in a changing world
ISBN: 978-1423902287
5th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd
Posted Date:
Students also viewed these databases questions
-
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...
-
Use the figure to make the lists in Exercises 8586. List the slopes m 1 , m 2 , m 3 , and m 4 in order of decreasing size. y y = mx + b y = mx + b X - y = m3x + b3 y = m4x + b4
-
A particular county employs three assessors who are responsible for determining the value of residential property in the county. To see whether these assessors differ systematically in their...
-
Which of the following statements is true if the NPV of a project is - $4,000 (negative $4,000) and the required rate of return is 5 percent? a. The project's IRR is less than 5 percent. b. The...
-
Carry out a pre-posterior analysis and find the expected value of perfect information (EVPI).
-
Financial Trends. You are a new city council person for the City of Scottsdale. Arizona. You are aware that several cities have been in the news recently for financial crises for which the council or...
-
1. Give a brief overview of CORPORATE TRAVEL MANAGEMENT LIMITED organisation. 2. Use VRIO analysis and Mackenzie's 7 model to analyse the external and internal environment of this organisation...
-
Example of Epic Proportions Twenty-five years ago Ronaldo, an accomplished cyclist, purchased a small custom carbon fiber wheel builder Zircles Inc. He applied their expertise in carbon fiber to...
-
What is one difference between crypto currency and fiat currency? Explain with examples.
-
Explain the essential components of a well-structured business letter. What should be included in the heading, salutation, body, closing, and signature? Provide examples of effective opening lines...
-
When should a business letter adopt a formal tone, and when can it be more conversational? Discuss the impact of tone on the readers perception and the context in which each approach is appropriate.
-
magine you are writing a business letter to convince a potential client to choose your companys services over competitors. How would you structure the letter? What persuasive techniques would you...
-
Provide a case study scenario where a customer has expressed dissatisfaction with your product or service. How would you draft a business letter to address their concerns, apologize, and propose a...
-
Consider a multinational corporation communicating with clients from diverse cultural backgrounds. How can business letters be adapted to respect cultural norms, avoid misunderstandings, and foster...
-
Dynasystem's trial balance shows $105,000 face value of bonds with a discount balance of $2,600. The bonds mature in 10 years. How will the bonds be presented on the balance sheet? A. Bonds payable...
-
Four GWU students have been selected to taste food sold by 3 different food trucks labeled as food truck A, B and C on H & 22nd Streets every Monday for 3-weeks. For each student, food trucks are...
-
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...
-
A construction contract differs from contracts that we generally deal with that focus on an easily defined physical object because the physical object can be examined. How is the object of a...
-
What does the owner contribute to the project and what does the contractor contribute to the project?
-
For what type of project is a line-of-balance schedule particularly suited? Identify specific examples.
Study smarter with the SolutionInn App