Táblé 1: Employees eid Init job dept dob Office location sname 2001 Stones Admin HR 3-12-1980 JHB 2002 Johnson K Salesrep Sales 12-4-1991 Midrand 2003 Nkosi F Manager Accounting 4-6-1978 Pretoria 2004 Dludla H Trainer Training 20-6-1985 JHB 2005 Dlamini J Manager HR 7-9-1976 Pretoria 2006 Pale K Admin HR 16-3-1997 Midrand 2007 Peter M Trainer Training 14-4-1969 JHB

Táblé 1: Employees eid Init job dept dob Office location sname 2001 Stones Admin HR 3-12-1980 JHB 2002 Johnson K Salesrep Sales 12-4-1991 Midrand 2003 Nkosi F Manager Accounting 4-6-1978 Pretoria 2004 Dludla H Trainer Training 20-6-1985 JHB 2005 Dlamini J Manager HR 7-9-1976 Pretoria 2006 Pale K Admin HR 16-3-1997 Midrand 2007 Peter M Trainer Training 14-4-1969 JHB

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Review: PVF manufactures high-quality wood furniture and distributes it to retail stores throughout the United States. Its product lines include dinette sets, stereo cabinets, wall units, living room furniture, and bedroom furniture. In the early 1990s, PVF’s founder, Alex Schuster, started to make and sell custom furniture in his garage. Alex managed invoices and kept track of customers by using file folders and a filing cabinet. By 1994, business expanded and Alex had to rent a warehouse and hire a part-time bookkeeper. PVF’s product line had multiplied, sales volume had doubled, and staff had increased to 50 employees. By 2000, PVF moved into its third and present location. Due to the added complexity of the company’s operations, Alex reorganized the company into the following functional areas: Manufacturing, which was further subdivided into three separate functions—Fabrication, Assembling, and Finishing Sales Orders Accounting Purchasing PINE VALLEY FURNITURE Alex and…
in process specification To create a decision * table it is necessary to list all external entities actions conditions entities users أخرى:
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
Draw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *
FIGURE 5.10 MAINTAINING MANAGER HISTORY Current Data EMPLOYEE DEPARTMENT PK EMP NUM PK DEPT ID EMP LNAME HE- manages EMP FNAME EMP INITIAL EMP E_MAIL JOB_CODE EMP SALARY DEPT NAME FK1 EMP NUM DATE ASSIGN EMP MGR_HIST %3 EMP SAL HISTORY Historic Data MGR HIST DEPT MGR_HIST SALARY HIST PK,FK1 PK,FK2 DEPT ID PK EMP NUM PK,FK1 EMP NUM PK DATE ASSIGN SALARY START DATE SALARY_AMT FIGURE 5.11 MAINTAINING JOB HISTORY EMPLOYEE Current Data PK EMP NUM DEPARTMENT EMP LNAME EMP FNAME EMP_INITIAL HE-- EMP E MAIL FK1 DEPT ID JOB CODE DATE_ASSIGN EMP SALARY PK DEPT ID manages DEPT NAME employs H-FK1 EMP_NUM DATE ASSIGN Historic Data JOB HIST DEPT JOB_HIST EMP_JOB HIST PK,FK1 EMP NUM PK,FK2 DEPT ID PK DATE ASSIGN PO JOB_CODE EMP SALARY
Question 2 Based on this EER diagram, which of the following statements about Author are correct? ISBN Edition Publication Title Book N Write Year Publication M Collection An author may have written nothing Every book has up to one author Start Date Volume Edit N Name End Eate Part of An author can write a book or contribute an article, but not both Author An author who has written a book has also contributed to an article N M N Name Editor Title Article N Contribute Publish Pages
While mingling with neighbours at a party, Ato mentions that he is responsible for evaluating bids fora large computer software contract. A few days later, Ato receives a lunch invitation from one of hisneighbours who also attended the party. Over appetizers, the conversation turns to the contract Atois managing. Ato’s neighbour seems remarkably well informed about the bidding process and likelybidders. Ato volunteers information about the potential value of the contract and briefly outlines thecriteria his firm will use to select the winner. At the end of the lunch, Ato’s neighbour surprises himby revealing that he is a consultant for several companies in the computer software market. Later thatday, Ato’s mind is racing. Did Ato reveal information that could provide a supplier with a competitive 5advantage in the bidding process? What are the potential business risks and ethical issues in thissituation? Should Ato report the conversation to someone? If so, whom should he talk to, and…
When a customer contacts the company to ask for an estimate, the proprietormakes a note of the customer’s contact details and an outline of the proposedwork. He agrees a date with the customer to view the property in order to givean estimate of the cost for the work. When visiting the property on the agreeddate the proprietor adds more detail to the outline of the proposed work. Within3 days of visiting the property the proprietor produces a fully detailed estimateand sends it to the customer. If the customer agrees the estimate, the proprietorschedules a date to start the job (this is based on the size of the job and otherjobs that have already been scheduled).A few days before the agreed start date of a job, the proprietor contacts thecustomer to confirm the start date, and then orders the required buildingmaterials from suppliers to be delivered on the date the job starts. At theend/completion of the job the proprietor calculates the actual cost of the job toproduce an invoice which…
Entity modeling is a top-down approach * that involves entities relationships tables foreign key classes هذا السؤال مطلوب
(1) Draw a sequence diagram for the “Apply for Leave” use case: Employers need to login into thesystem using correct username and password, input the start and end date of the asking for leave,and then submit the request to the leader of the department. The leader approve the request or not. Ifthe leader approve the request, the request will be submitted to the HR to process. HR will decidewhether to approve the request according to the regulation of the company, and then send the finaldecision to employers and Accounting staffs. (2) Build an activity diagram to describe the “Apply for Leave” in question (1).
Project Synopsis: ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a…
Make an entity relationship diagram with the following data: Patient Entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Email: String Address: String Telephone numbers: String Pension System: String Health Insurance Entity: Code (primary key): Integer Type: String Medical entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Specialties: String Years of practice: Integer Medical Specialty Entity: Code (primary key): Integer Specialty Name: String Pharmaceutical company entity: Code (primary key): Integer Name: String Phone number: String Medication Entity: Business name (primary key): String Formula: String Pharmaceutical company code (foreign key): Integer Pharmacy Entity: Code (primary key): Integer Name: String Address: String Phone number: String Patient-Physician Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer Start date: Date End date:…