Database Access Assignment- Computer or Tablet Assignment:

#5 Database Access Assignment- Computer or Tablet Assignment: Student Learnin" rel="nofollow">ing Objective: Students will design a relational database, enter records, create queries, and reports. You may design a relational database of your own design OR use the followin" rel="nofollow">ing storylin" rel="nofollow">ine. Background Storylin" rel="nofollow">ine: You are asked to design a relational database for an onlin" rel="nofollow">ine nutrition tracker program. Participants log on to the site and provide their first and last names, address, phone number, and email address. They in" rel="nofollow">input their daily food in" rel="nofollow">intake in" rel="nofollow">in 3 areas of nutrition. Carbohydrates, Fats, and Protein" rel="nofollow">ins (e.g. 40% carbs, 30% fats, 30% protein" rel="nofollow">ins) At the end of the week a report is run to determin" rel="nofollow">ine if they have stayed “on target” for their percentages. Student Task: * You will create your own scenario and related data with similar requirements. OR * You will create data based upon the storylin" rel="nofollow">ine above. o At least 6 participants o At least 7 days of nutrition percentages for each participant o At least 3 different levels of “on target” goals * You will design a relational database in" rel="nofollow">in Access. o Chart out a table for each entity, all fields and the primary Key. * You will in" rel="nofollow">input your in" rel="nofollow">invented data in" rel="nofollow">into Access tables. * You will create queries and generate reports to be used at the next management meetin" rel="nofollow">ing. * Send your entity relationship diagram, tables, and summary reports to your class D2L Assignment dropbox.