Track of each customer''s workout routine on any given day

Reference no: EM13250623

1. Create one new table to keep track of each customer's workout routine on any given day. The table will need to be designed to record each customer performing at least one exercise on any given date and time. A customer will likely have several records per day. The actual details of the design will be left to you. All fields must be atomic and each record must contain enough information to adequately report on a customer's workout routine. Also, remember that each record must have a unique identifying field.

2. You must create relationships between all four tables in your database. In the case of this new table, your grade will be based on your naming convention (how you name the table), the structure of the table (are all elements atomic?), the relationships established (are they appropriate and correct?), the data types selected (are they appropriate and correctly sized?) and the data you used to populate the table.

Reference no: EM13250623

Questions Cloud

Find the work done on the object by the force : A single force acts on a 4.4 kg particle-like object in such a way that the position of the object as a function of time is given by x = 3.8t - 4.6t2 + 1.3t3

What types of support could you offer this mother : Thinking about the mother has child with a disabilityb, imagine you had a parent meeting with her, and she sat dazed, confused and hopeless. What could you, as a teacher, do to offer support or encouragement? What types of support could you offer th..

Xyz plc provides engineering and consultancy services : XYZ plc provides engineering and consultancy services tothe oil and gas industry. Over the past few years, they have incurred expenditure of £1m researchingand developing a new product, the "UniSensor" for which they have registered a patent.

Under the federal sex offender registration : Under the Federal Sex Offender Registration and Notification Act, sex offenders must register and update their registration as sex offenders when they travel from one state to another.

Track of each customer''s workout routine on any given day : Create one new table to keep track of each customer's workout routine on any given day. The table will need to be designed to record each customer performing at least one exercise on any given date and time. A customer will likely have several recor..

Find the steady state concentration of formaldehyde : A home (volume = 1000 m3) built in 1946 has urea formaldehyde insulation, which outgases into the home at a rate of 5 ng/hr, What is the steady state concentration (C) of formaldehyde in the home

Explain the constant pressure and amount of gas : A 500 ml sample of O2(g) is at 780 mmHg and 30C. What will be the new volume if, with the constant pressure and amount of gas, the temperature is decreased to -15c

Determine the average axial stress in the post : A 139 x 139 timber is used as a short foundation post. It must support a load of 42 kN. Determine the average axial stress in the post

Significance to ancient greek culture : Discuss here two (2) specific items or informational bits that you learned, and suggest their significance to ancient Greek culture and the western heritage in the arts

User Account

All Pages