search

G915-2-Data-Modeling-381 / Project-1-eStreamingMovies

Collaborate and use the best from each of the group member's individual project and create the modernized YourName-eStreamingMoviesSqlServer2019-yyyymmdd. Highlighting the individual's contributions for the best solution. Read the Project one Specification Read the Project plan
0 stars 0 forks source link

Write definitions & attributes for Employee and Customer Service #30

Closed ambergarcia closed 1 year ago

oliverVidalCs commented 1 year ago

Employee

EmployeeNumber PK Supervisor FK EmployeeAddress EmployeeAddress2 EmployeePhone HireDate Salary Position Email StoreNumber

CustomerService

ServiceRequestNumber PK AccountNumber FK EmployeeNumbers FK Report FK EmployeeReport TicketStatus CustomerSurvey

oliverVidalCs commented 1 year ago

Definitions:

Employee

The Employee is an entity that assists customers by processing payments, facilitating purchases such as rentals, and even helping with customer issues through customer service

Customer Service

Customer Service is an entity that resolves an issue that the customer has with the streaming platform by connecting the customer and forwarding the matter to an employee who will help assist the customer with the issues they are facing.