Question
Please carefully analyse the transcript of an interview between an external database designer (DD) and the business owner (BO) of company ABC given below. DD
Please carefully analyse the transcript of an interview between an external database designer (DD) and the business owner (BO) of company ABC given below.
DD: Could you please briefly introduce the business of your company?
BO: Our main business covers wallpaper and accessories. We have a few branches and each customer places orders through a branch, and each branch may have many customers. A customer may place many orders, but he or she does not always have to order through the same branch all the time.
DD: What customer information would you like to track?
BO: We need to record customers' full name, including title, first name and last name, as well as their contact details, e.g., landline or mobile number. Our customers may have one or more accounts, although they may also have no accounts. For each customer's account, we need to record Balance, Last payment date, Last payment amount and Type.
DD: Can you explain more about the orders placed by your customers? And what do you need to track in the orders?
BO: Sure. Each order is composed of one or more items, and an item may be involved in more than one order. We need to know Order Date and Credit Authorization Status. Each item has Description, Colour, Size, Pattern, and Type.
DD: Do you want to track the internal employees' information?
BO: Definitely. We have 66 employees and their information including full name (first name and last name), mobile number, date of hire, salary and DOB, is required to be recorded. Each employee works in one and only one branch. An employee may or may not have a direct manager. I have given you pretty much information. Do you have any other questions?
DD: I think that's good enough... Oh, one more question. What information about a branch do you need to record?
BO: Branch Number and the address, including Street, City, State and Post Code. It just reminds me that each branch has a manager responsible for day-to-day operations.
DD: Got it. Thank you!
Based on the information in the interview transcript above, use Visual Paradigm to make the logical Entity-Relationship (ER) Diagram using the Crow's foot model symbols and include all attributes. Your diagram must:[1]
(a)Identify (i) strong and weak entities and (ii) identifying and non-identifying relationships.
(b)Identify the main attributes in each entity including all primary and foreign keys
(c)Identify the cardinality and participation (mandatory/optional dependencies) for all the relationships
(d)Resolve all M:N relationships
[1] Please note: You don't need to answer these questions separately. You identify them in the diagram.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started