Redraw the given figure 2-4a for the revised situation described as follows: Consider a slightlydifferent situation. Suppose it is necessary, for compliancepurposes (e.g., Sarbanes-Oxley compliance), to know when each expense report was produced and which officers(not just the treasurer) received each expense report and when each signed off on that report.

Question

Want to see the full answer?

Answer 1

Question

Chapter 2, Problem 2.43PAE

Program Plan Intro

Redraw the given figure 2-4a for the revised situation described as follows:

Consider a slightlydifferent situation. Suppose it is necessary, for compliancepurposes (e.g., Sarbanes-Oxley compliance), to know when each expense report was produced and which officers(not just the treasurer) received each expense report and when each signed off on that report.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Draw clearly from existing scenario text the Entity Relationship Diagram (ERD) “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a…

Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…

Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A Medical store has many branches throughout country. The data held on each branch is the branch address made up of street, city, and zip code, and telephone number. Each branch is given a branch number, which is unique throughout the country. Each branch is allocated at least one staff member. Each staff member must belong to exactly one branch. The data held on a member of staff is his or her name, position and salary. Each member of staff is given a staff number, which is unique throughout the country. Each branch has a one or many products. A product belongs to exactly one or many branches. The data held on a product is the product number (identifier), title, category, price, and available quantity. Each product is purchased from exactly one vendor. From one…