Question: You work in a dentist office. Here are the data tables: Patient (PatientNum, HouseholdNum, PatientName) Household (HouseholdNum, HouseholdName, Street, City, State, Zip, Balance) Service (ServiceCode,

You work in a dentist office. Here are the data tables: Patient (PatientNum, HouseholdNum, PatientName) Household (HouseholdNum, HouseholdName, Street, City, State, Zip, Balance) Service (ServiceCode, Description, Fee) Appointment (PatientNum, ServiceCode, Date) Which data needs to be archived? When should it be archived? Should the data be archived with data from another table?

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Hi there , I need help. for my work i need a relevant and well written introduction as well as conclusion to the following below. My work is complete i just need a introduction and conclusion please...

Job descriptions: In determining who will be responsible for what duties, you are to compile a Job description for the Assistant Front Office Manager, The Front Desk Agent, The Reservations Agent and...

You work in a dentist office . Here are the data tables : Patient ( PatientNum , HouseholdNum , PatientName ) Household ( HouseholdNum , HouseholdName , Street , City , State , Zip , Balance )...

You work in a dentist office. Here are the data tables: Patient (PatientNum, HouseholdNum, PatientName) Household (HouseholdNum, HouseholdName, Street, City, State, Zip, Balance) Service...

third normal form (3NF). PATIENT(HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum, PatientName,(ServiceCode, Description, Fee, Date)) the answer for the above...

Create MySQL ERD 1NF: PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date) PK: PatientNum 2NF: PATIENT_HOUSEHOLD...

Make a mySQL ERD 1NF: PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date) PK: PatientNum 2NF: ...

The requirements shown in Question 11 have changed. The dentists office would like to add the date of the patients last payment. In which relation (table) would you place this attribute? Why? Data...

Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household....

State Street Beverage Company issues $802,000 of 11%, 10 -year bonds on March 31, 2017. The bonds pay interest on March 31 and September 30. Which of the following statements is true? O A. If the...

The information of Chocolate Berhad is described as follows: RM600,000 200,000 400,000 150,000 250,000 50,000 200,000 60,000 RM140,000 Sales Variable costs Total contribution margin Fixed costs EBIT...

This is your opportunity to prove why your new product or service deserves funding. You ve done the research, and you understand that the investment you re seeking could be a game - changer for the...

At 6,650 ft TVD a permeable gas reservoir is drilled that could have a pore pressure gradient as high as 12.0 ppg. a) What mud pressure (in psi) and mud weight (in ppg) should be used if ChevBob...

Sandra stopped working, and stopped contributing to the Canada Pension Plan, on her 65th birthday. At age 65, she applied for and began to receive her CPP retirement income. Her birthday falls on...

TED AND ALICES HOUSE PURCHASE DECISION Ted and Alice are a young couple who have been living in an apartment for the first two years of their marriage. They would like to buy their first house, but...

How many moles of CO, are contained in an 18.1 L sample at 0.87 atm and 25C? A 0.64 7.6 1.6 D 0.13 E None of the above C.

Use the data given here to calculate the values of AGAN at 25 C for the Compound AG; (kJ/mol) reaction described by the equation A +387.7 +596.8 A +B =C C +402.0 AGrxn kJ

1. Discuss the aspects in which the top leadership of Alibaba performed well, and which areas need further improvements. 2. Explain how Jack Ma and his leadership team had challenged or could have...

Describe the purpose of the INTERSECT command in relational algebra.

Why is system availability an advantage in a distributed database?

What three types of actions do users typically perform when they use OLAP software?

PayScale is a source of online compensation information, providing access to accurate compensation data for both employees and employers. PayScale allows users to obtain compensation information...

The Cozine Corporation operates a garbage hauling business. Up to this point, the company has been charged a flat fee for each of the garbage trucks that enters the county landfill. The flat fee is...

Zepolles Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of Zepolles problems is that the number of loaves of each type of bread sold each day by the chain...