Answer Happy

Logical Method
The Smart Solutionscompany has been founded to
providenetworkingservices.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 consultantsand
technical consultants. Business services cannot be provided by
technical consultants, and technical services cannot be provided by
business consultants.
•A customercompany contacts the Smart Solutionswith the aim to
estimatethe costof servicesthey want. The Smart Solutionssends a
business consultantto the customerlocation. The business
consultantdetermines the customer IT needs and provides an
estimatefor the actual servicesto be performed.
•The following attributes of a business consultantare stored in
the database:
oEmployeeIDoNameoAddress(Street, City, State, and PostCode)
oPhoneoDOB(date of birth)oAgeoDegrees(degrees received)
oBusinessTypes and NumberOfYears(how many years of experience in
the business)
•The following attributes of a technical consultantare storedin
the database:
oEmployeeIDoNameoAddress(Street, City, State, and PostCode)
oPhone
oDOB
oAge
oDegrees
oTechnicalSkills
•The following attributes are of customersare stored in the
database:
oCustomerID
oCompanyName
oAddress(Street, City, State, and PostCode)
oContactName
oContactPhone
oBusinessTypeoNumOfEmployees(number of employees)
•Customers can have multiple locations. Attributes of a location
are:
oCustomerID
oLocationID(unique for each customer ID)
oPhone
oBuildingSize
•A networking serviceis performed for a customer at one or more
locations. Before servicesare performed, an estimateis
prepared.Attributes of a serviceare:oServiceIDoDescriptionoCost
•An estimate is prepared for a customer, by a business
consultantand includes one or more services. The attributes of the
estimate are oEstimateDateoEstimateAmount
•Another entity is ServicePerformed related to the services
carried out bya technical consultantata location. The
ServicePerformedattributes are:oSP_Date(Service performed
date)oSP_Amount(Service performed $ amount)
•Acustomer can have many consultants providing many
services.
•Notethat estimateprovided by a business consultantis different
from a service performedby a technical consultantas
oAn estimatecan be also a quote before the service to be
provided(or never provided)
oThe estimate amountcan be different from the service
performedamountYour assignment submission consists of two
parts.
Part1. 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