Answer Happy

The Smart Solutions company has been founded to provide
networking services. The company decided to develop an Information
System to support business processes. Business analysts gathered
database requirements, and which can be formulated as • There are
two types of consultants: business consultants and technical
consultants. Business services cannot be provided by technical
consultants, and technical services cannot be provided by business
consultants. • A customer company contacts the Smart Solutions with
the aim to estimate the cost of services they want. The Smart
Solutions sends a business consultant to the customer location. The
business consultant determines the customer IT needs and provides
an estimate for the actual services to be performed. • The
following attributes of a business consultant are stored in the
database: o EmployeeID o Name o Address (Street, City, State, and
PostCode) o Phone o DOB (date of birth) o Age o Degrees (degrees
received) o BusinessTypes and NumberOfYears ( how many years of
experience in the business) • The following attributes of a
technical consultant are stored in the database: o EmployeeID o
Name o Address (Street, City, State, and PostCode) o Phone o DOB o
Age o Degrees o TechnicalSkills • The following attributes are of
customers are stored in the database: o CustomerID o CompanyName o
Address (Street, City, State, and PostCode) o ContactName o
ContactPhone o BusinessType o NumOfEmployees (number of employees)
• Customers can have multiple locations. Attributes of a location
are: o CustomerID o LocationID (unique for each customer ID) o
Phone o BuildingSize • A networking service is performed for a
customer at one or more locations. Before services are performed,
an estimate is prepared. Attributes of a service are: o ServiceID o
Description o Cost • An estimate is prepared for a customer, by a
business consultant and includes one or more services. The
attributes of the estimate are o EstimateDate o EstimateAmount •
Another entity is ServicePerformed related to the services carried
out by a technical consultant at a location. The ServicePerformed
attributes are: o SP_Date (Service performed date) o SP_Amount
(Service performed $ amount) • A customer can have many consultants
providing many services. • Note that estimate provided by a
business consultant is different from a service performed by a
technical consultant as o An estimate can be also a quote before
the service to be provided (or never provided) o The estimate
amount can be different from the service performed amount Your
assignment submission consists of two parts. Part 1. Conceptual
Model • Identify entities • Identify entity supertypes and
subtypes. Describe inheritance types and the corresponding
discriminators. • Identify multi-valued and composite attributes
(if any). In this case, they need to be shown in the ER diagram
with the corresponding notations. • Describe relationships between
entities and their cardinalities • Identify entity identifiers •
Draw a Conceptual Model Entity-Relationship diagram Part 2. Logical
Model • Describe data attributes and their types for each entity •
Redesign the Conceptual model removing many-to-many relationships
(if any) • Identify primary, composite (if any) and foreign keys
(if any) for each entity • if there are any one-to-one
relationships then describe them • Draw a Logical Model diagram