Question
PLEASE LIST THE ENTITIES AND RELATIONSHIP SATISFYING THE BELOW QUALIFICATIONS USING THE GIVEN ERD GIVEN BUSINESS RULES: . An IT company has hired many employees.
PLEASE LIST THE ENTITIES AND RELATIONSHIP SATISFYING THE BELOW QUALIFICATIONS USING THE GIVEN ERD
GIVEN BUSINESS RULES:
. An IT company has hired many employees. Each employee can only be employed by one IT company due to non-competition and non-solicitation agreement.
2. Employees may handle one or more customers with their IT needs. Customers can change employee representatives but may only have one at a time.
3. A customer may choose different types of IT services depending on their needs including Network Security, Cloud Computing, Software Support, etc. Services can be provided to many customers.
4. Each service has a specific price that is provided to the customer by the Company Employees.
5. Each customer can issue payment through different modes/types. The payment system contains the payment type, amount, and the date of payment.
Entities that includes:
Entitys name
Entitys description
List of attributes
Data type of each attribute (numeric, text, or date)
Sample data for each attribute
Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NULL where applicable)
Each entity must be described in the section. You must have a minimum of 4 entities. The total number of entities recommended is 4-5.
Relationships that includes:
A copy of a specific business rule from the Business Rules section for each relationship described here.
Relationships type: 1:1, 1:M, M:N. Use business rules to justify your decision.
Relationship strength: strong or weak. Use business rules to justify your decision.
Optionality for both sides of each relationship: mandatory or optional. Use business rules to justify your decision.
Each relationship must be described in the section. Each M:N relationship must be resolved and described.
EMPLOYEES EMP_ID IT COMPANY PK COMP_ID COMP_LOCATION COMP_DESC HAS EMP_FNAME EMP_LNAME COMP_ID HANDLES CUSTOMER CUSTOMER_ID PK L NAME F NAME ISSUES - PAYMENT PK PAYMENT_ID PAYMENT_TYPE PAYMENT_AMOUNT PAYMENT_DATE ST_ADDRESS ZIP CODE CUST_CITY CUST STATE PHONE NUMBER EMP_ID CHOOSE E SERVICE TYPE PK,FK1 SERV_CODE PK,FK2 CUSTOMER_ID SERVICE_QUANT INCLUDES - SERVICES PK SERV_CODE SERV_PRICE SERV_DESCRIPTION CUSTOMER_ID EMPLOYEES EMP_ID IT COMPANY PK COMP_ID COMP_LOCATION COMP_DESC HAS EMP_FNAME EMP_LNAME COMP_ID HANDLES CUSTOMER CUSTOMER_ID PK L NAME F NAME ISSUES - PAYMENT PK PAYMENT_ID PAYMENT_TYPE PAYMENT_AMOUNT PAYMENT_DATE ST_ADDRESS ZIP CODE CUST_CITY CUST STATE PHONE NUMBER EMP_ID CHOOSE E SERVICE TYPE PK,FK1 SERV_CODE PK,FK2 CUSTOMER_ID SERVICE_QUANT INCLUDES - SERVICES PK SERV_CODE SERV_PRICE SERV_DESCRIPTION CUSTOMER_IDStep 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