please help 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 a 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 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. (Hint: Two Tables Only)

2. Copy (in another tab) your ERD from #1, but this time include 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 lab test administered to a client is associated with one test type. A test type can be administered to multiple clients. A test type can exist in the database without ever being administered. (Hint: You should now have Three Tables.)

3. Copy (in another tab) your ERD from #2, but this time include 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. (Hint: 5 Tables)

4. Copy (in another tab) your ERD from #3, but this time include lab test results. Each administered lab test has a result for each item on the test type. A test item result includes a unique test item results identifier, the analysis date, the employee identifier of the lab technician measuring the result, the measured value of the test type item, and an optional description of the test items appearance. An administered lab test has one or more associated test item results although there are no associated results until lab analysis is complete. A test item can have many associated test item results. Test items never administered will not have any associated test item results. (Hint: 6 Tables)

5: In another tab, draw an ERD for the following Scenario Hogle Zoo wants to maintain information about its animals, the enclosures in which they live, and its zookeepers and the services they perform for the animals. In addition, Hogle Zoo has a program by which people can be sponsor of animals. Hogle Zoo wants to track its sponsors, their dependents, and associated data. Each animal has a unique animal number, species, name (Jumbo, Fred, etc.), gender, country of birth, and weight. Enclosures have a unique enclosure number, type (cage, fenced field, etc.), location, size, and date built. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. A zookeeper has a unique employee number, employee name, title, and year hired. Some zookeepers supervise other zookeepers. Every animal has been cared for by at least one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a specific, significant service for an animal the service type, date, and time are recorded. A sponsor sponsors at least one and possibly several animals. An animal may have several sponsors or none. A sponsor has a unique sponsor number, a name, address, and telephone number. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. In addition, Hogle Zoo wants to keep track of each sponsors dependents, keeping their name, relationship to the sponsor, and date of birth. A sponsor may have several dependents or none. A dependent is associated with exactly one sponsor.

6: In another tab, draw and ERD for the following (more complex) scenario. Use the discussion forum to ask questions and think this through PurpleBox is a database system which keeps track of the information about Movie Rentals (Blu-ray & DVD format) as well as customers. It will be used in a Movie rental shop on Webers main campus. Without the use of this database system the rental shop will have to maintain scattered inventory records and customer information. A centralized database will help to provide general accessibility to this information as well as ensure the data are preserved more securely. The Business Logic (Note: a Database cannot always enforce business logic. Your focus should be on data storage and organization trying to accommodate these rules. Business rules are typically enforced on the Program Level, but some things can be factored into the DB design). The rental shop has users who can either be administrators (Admin) or customers. All users have a unique ID to identify them. The administrators manage the database and have authority to modify the database. The customer can only borrow DVDs/Blu-Rays (hereby referred to as Movie Items) from the shop. A person can be both administrator and customer. For each user, we maintain several descriptive attributes. Some important ones are security features like password for authentication and ID verification question and answers. We may have one or more phone numbers for every user. There are two kinds of customers: normal and premium. All customers have to be only one of the two types. The difference between the two kinds is that normal customers get to rent up to 2 Movie Items using their account, whereas premium customers get to rent up to 4 Movie Items. Another privilege to premium customers is that they can "request" up to 4 Movie Items. That is, even if the Movie Item is not available at the store, the customer can request to reserve that Movie Item for him/her whenever a copy is returned. Normal customers do not have the privilege of doing this and can only rent from whats available in the store at the current time. Each customer is can only rent Movie Items if he/she hasnt exceeded the quota allocated and if he/she is not banned. A customer can be banned by an admin depending on the situation. For example, a customer may be banned for not returning Movie Items for an extended period of time or situations may arise when the shop no longer wants to service a particular customer. This ban is a temporary ban and can be changed by admin as situation changes. It is to be noted that every Movie Item entity has a unique ID. However the store can have multiple copies and formats of each movie. Each copy of these movies is identified with the combination of Movie ID and item copy number. When a customer rents a Movie Item, he/she actually rents a copy of the Movie - called an item. Example: "Titanic" is a Movie...but your DVD copy at home is an Item. A customer may rent copies of the same of different Movie Items according to his/her quota. Whenever a Movie Item is rented by a customer, we maintain the rental date as well as the return date, if the customer returns the Movie Item after the due date, he is charged with overdue fees depending on how many days hes exceeded his due date. We maintain a table with information related to directors. Every Movie Item (meaning the movie itself) has to be directed by one or more directors. We also maintain a table with information related to actors. Again every Movie Item has to have at least one actor in it however, we may maintain information of actors and directors that do not belong to any Movie in the database. A Movie may have one or more genre (for example, action, comedy, horror, etc.) A Movie may also have multiple keywords associated with it so that its easier for the customer to search a Movie Item based on words that suggest the contents or words that are included in the title of the Movie Item.