a) Which of the following is one of the entities in this scenario? employees, ad

Question

a) Which of the following is one of the entities in this scenario?
employees, address, tax file number, client no, employeeClients
b) Which of the following is an attribute of the invoice entity in the scenario?
notes, salesEmployee, InvoiceNumber, EmployeeNumber, jobNumber
c) Which of the following relationships would be present in an accurate model of the scenario, and would have attributes assigned to it?
contacts and clients, clients and jobs, jobs and employees, clients and employees, jobs and invoices
d) Which of the following accurately depicts the relationship constraints between the clients (companies) and jobs entity types?

Consider the following scenario for Questions 7 to 10 Joey's Designs is a graphic design company operating in Brisbane. They would like a database to store records about the work that they do Joey's Designs does work for other companies. They keep on file each company's name and address, as well as the first name, last name, phone number, position and email address of up to three contacts at the company There are a number of employees that work for Joey's Designs, including sales representatives, designers, and managers. Each employee has an employee number, and records of their first name, last name, home address, phone number, TFN, DOB and role are kept. Each client company is managed by a sales employee at all times, although sometimes the responsible employee is changed. Records are kept of when each employee is responsible for a client so that performance data can be calculated. Each job requested by a client company is recorded and assigned a job number. The status of the job, employee responsible for producing the work, and any work notes are stored One or more invoices are generated for every job. When an invoice is generated it is assigned an invoice number. The amount of the invoice, and the payment status is also recorded

Explanation / Answer

a)Which of the following is one of the entities in this scenario?

Employee

b)Which of the following is an attribute of the invoice entity in the scenario?   

Invoice number
c) Which of the following relationships would be present in an accurate model of the scenario, and would have attributes assigned to it?
clients and jobs
d) Which of the following accurately depicts the relationship constraints between the clients (companies) and jobs entity types?

Option A

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.