4. The following table lists the time spent by employees of Purple Print Agency and their project to work at two zones (with empNo, project No being the primary key).. emp No project No hoursPer Week emp Name zoneCode location K123 C13 15 Ali Z12 Bangi A124 C13 22 Zara Z12 Bangi A345 C24 27 Naim Z5 Kajang K123 C24 15 Ali Z5 Kajang TABLE 3: EMPLOYEES WORK HOURS

4. The following table lists the time spent by employees of Purple Print Agency and their project to work at two zones (with empNo, project No being the primary key).. emp No project No hoursPer Week emp Name zoneCode location K123 C13 15 Ali Z12 Bangi A124 C13 22 Zara Z12 Bangi A345 C24 27 Naim Z5 Kajang K123 C24 15 Ali Z5 Kajang TABLE 3: EMPLOYEES WORK HOURS

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A. Draw ER Model For the company B. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. C. to youhave any associative entities on your ERD? If so, what are the identifers for those associative entities?
You are required to develop a simple database application for a small recruiting firm that wishes to keep track of all the employees at the firm; storing details about their name, phone numbers, hiredate, Gender, Date of Birth, Salary, and Commission. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe allocated one car. To ensure timely maintenance of vehicle, the company would like to store the following details of the vehicle: make, model, next_maintenance_date. Each employee has a position (manager, accountant, administrator, clerk, HR employee, etc.). Various allowances are allocated to each position. For example, the managers have fuel allowance, house allowance, social allowance and managers allowance. On the other hand, the administrators have house…
Entity Relationship Diagram Can you make changes because I think I made some mistakes while working on these entitties and implement the relationships of this ERD? (see attached photo)
Q1
can you help me create a Data flow diagram based on this system analysis please.
Draw ER diagram for the following upload the diagram ?? A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A. chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.
When you create a new job category – Select one: a. all employees are assigned to the new category initially b. no employees are assigned to new category initially c. all employees in this category are not salespersons initially d. you cannot assign an employee from another category to the new category at the same time.
Identify week entity in the following scenario: "Students registered in a particular course section of a specific course". AS. A. Course Section B. Course C. Student D. Register Foc 耳 hp f10
Draw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…
Create a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptions
How would you define a pattern? SCRUM is referred to be a pattern for a certain objective.
Explanation In the first example, your initial amount of money is $200, which enable you to invest in the first, second, fourth and fifth project that needs only $200 each. By establishing these four projects apart, the investor will have $200*4 (profit) +$200 (initial basic) = $1000. This amount of money will enable the establishment the 3rd project that needs $500 of investment to gain $200 of profit. Finally, to calculate the overall profit, you have collected $1200, where $200 of them are the initial basic and hence the profit is $1200 - $200 = $1000. In the second example, your initial amount of money is $150, which enable you to invest in the 3rd project only. By doing so, your budget will increases to $200 and hence be able to invest in the 1st project to again increase your budget to $290. However, this is not enough to invest in the 3rd project. Finally, you collected $290, where $150 of them are the initial basic and hence the profit is $290 - $150 = $140. """ I want…