Reference no: EM132896003

1. Draw an ERD to track lab tests performed by a medical laboratory on clients. The database should track basic client details including a unique client identifier, client name, client insurance provider (if any), client address, client date of birth, and client sex. The database should track the unique identifier for the lab test, the test type identifier, the date and time when the lab test was administered, and the identifier of the lab employee performing the lab test. A client can request multiple tests in a visit to the lab. The database only contains clients who have had lab tests performed. Each lab test is administered to one client.

2. Revise the ERD from problem 1 with more details about test types. A test type includes a unique test type identifier, a test type name, a test type cost, and a test type code. A test for a client is associated with one test type. A test type can be used in multiple tests given to clients. A test type can exist in the database without ever being used in a test given to a client.

3. Revise the ERD from problem 2 with test type items. A test type item includes a unique test item identifier, a test item name, test item unit of measure, and a test item description. A test type includes one or more test items. A test item can be part of one or more test types.

4. Revise the ERD from problem 3 with a limited history of test type costs. The revised ERD should contain the current test type cost and the two most recent test type costs. Apply the appropriate transformation from Chapter 6 for a limited history of test type costs.

5. Revise the ERD from problem 3 with an unlimited history of test type costs. Apply the appropriate transformation from Chapter 6 for a unlimited history of test type costs.