Answer questions of items (a) and (b) based on the customer database given in Figure 1....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Answer questions of items (a) and (b) based on the customer database given in Figure 1. You are encouraged to make assumptions of any new entities that may seem relevant. Marketing department of ABX recruitment requires a customer database based on the following requirements; Persons are identified by a combination of their first name, last name, and date of birth. A person can have an arbitrary number of titles (E.g., Prof. Dr. Karin Knight). For cooperation we record the sector (e.g., IT) and a unique name to represent the cooperation. Persons work for one or more cooperation's. For each relation between a person and a cooperation we record a job title. There are situations where some cooperation in our database don't have any associated employees. Addresses consist of a street, street number, zip code, city, state, and a unique Id. A person can be associated with an arbitrary number of addresses and multiple persons can live at the same address. A cooperation is associated with one or more addresses. No two cooperation's share the same address. Some addresses in the database may not be associated with any cooperation or person. Phone contacts consists of a type (e.g., home or work) and are uniquely identified by a combination of area code and number (e.g., 312 and 123456). Each person is associated with at least one phone contact. Each phone belongs to exactly one person. Some, but not all phone contacts are associated with an address. We allow multiple phone numbers for the same address. An email address consists of an unique address string (e.g., krinknight@sit.edu.my). Each email address has one owner (a person), but not all persons have an email address. We do not record multiple email addresses per person. Figure 1: Customer database a) List all the entities required for requirements given in Figure 1. (10 marks) b) Draw the complete entity-relationship diagram for requirements given in Figure 1. (20 marks) Answer questions of items (a) and (b) based on the customer database given in Figure 1. You are encouraged to make assumptions of any new entities that may seem relevant. Marketing department of ABX recruitment requires a customer database based on the following requirements; Persons are identified by a combination of their first name, last name, and date of birth. A person can have an arbitrary number of titles (E.g., Prof. Dr. Karin Knight). For cooperation we record the sector (e.g., IT) and a unique name to represent the cooperation. Persons work for one or more cooperation's. For each relation between a person and a cooperation we record a job title. There are situations where some cooperation in our database don't have any associated employees. Addresses consist of a street, street number, zip code, city, state, and a unique Id. A person can be associated with an arbitrary number of addresses and multiple persons can live at the same address. A cooperation is associated with one or more addresses. No two cooperation's share the same address. Some addresses in the database may not be associated with any cooperation or person. Phone contacts consists of a type (e.g., home or work) and are uniquely identified by a combination of area code and number (e.g., 312 and 123456). Each person is associated with at least one phone contact. Each phone belongs to exactly one person. Some, but not all phone contacts are associated with an address. We allow multiple phone numbers for the same address. An email address consists of an unique address string (e.g., krinknight@sit.edu.my). Each email address has one owner (a person), but not all persons have an email address. We do not record multiple email addresses per person. Figure 1: Customer database a) List all the entities required for requirements given in Figure 1. (10 marks) b) Draw the complete entity-relationship diagram for requirements given in Figure 1. (20 marks)
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
The following are some examples of typical business transactions: 1. Purchased office equipment on credit. 2. The owner contributed capital. 3. Purchased office furniture for cash. 4. Received...
-
Suppose 1 and 2 are true mean stopping distances at 50 mph for cars of a certain type equipped with two different types of braking systems. Use the two-sample t test at significance level .01 to test...
-
The Japanese stock market bubble peaked at 38,916 in 1989. Two and a half years later it had fallen to 15,900. What was the percentage decline?
-
How is the power of art related to performance and emotion?
-
Paul Swanson has an opportunity to acquire a franchise from The Yogurt Place, Inc., to dispense frozen yogurt products under The Yogurt Place name. Mr. Swanson has assembled the following information...
-
What potential solutions can organizations try to help support the adoption of a CDSS? In other words, what are some ways an organization can address the factors of implementation obstruction that...
-
Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively,...
-
a. What is the maximum throughput rate for Product Valentine? b. What is the (minimal) theoretical cycle time? c. Assume that the operator of machine C has come up with an innovation that has reduced...
-
What is the present value of the selling price of a $1,000, 8% bond (interest paid semi-annually) if comparable market interest rates rise to 10% and the bond matures in 14 years?
-
A corporation has 10,000 bonds outstanding with a 6% semi-annual coupon rate, 10 years to maturity, a $1,000 face value, and a $1,100 market price. The company's 100,000 shares of preferred stock pay...
-
The general ledger trial balance of Paradiso Ltd, a medical manufacturing and research company, includes the following accounts at 30 June 2022. Sales revenue $ 2 600 000 Interest income...
-
What is the present value of $3,000 per year for 9 years discounted back to the present at 11 percent?
-
9. On January 1, 2017, Brad Company sold goods to Tad Corporation. Tad Corporation signed a 6-year note with a face amount of $80,000 and a stated interest rate of 6%. The note pays interest annually...
-
On the balance sheet for a manufacturing business, the cost of direct materials, direct labor, and factory overhead are categorized as either materials inventory, work in process inventory, or...
-
Discuss whether responsible human resources management should apply different standards for the home company and suppliers, for developed countries and developing countries, and for large companies...
-
Interview a variety of people about the various ways they interact, in terms of inputs, with systems at their workplaces. What types of technologies and devices are used to deliver these inputs? Are...
-
Use the outline for the BPP provided in Figure 5-9 to present the system specifications for the information system you chose for Problem and Exercise 5-35. Problem and Exercise 5-35. Consider your...
-
Search the web for information related to web services and the associated technology standards being utilized. Specifically, compare and contrast SOAP and REST using the various characteristics you...
-
Under what conditions can WTO members not use MFN when dealing with one another?
-
What does most favored nation (MFN) mean?
-
Why do free trade areas develop rules of origin?
Study smarter with the SolutionInn App