Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Base on the case study, determine whether is entity relationship diagram erd or enhanced entity relationship diagram eerd and draw complete flowchart diagram. example of
Base on the case study, determine whether is entity relationship diagram erd or enhanced entity relationship diagram eerd and draw complete flowchart diagram.
example of answer:
Case Study: An online system for AK Solutions and Services (AKSS) A relational database is to be designed for this company- Ak Solutions and Services (AKSS). It is a medium sized company dealing with applications of computers and services. The Company delivers various products to its customers ranging from a single application program, customized software and to complete installation of hardware. The Company employs various experts, consultants and supporting staff. All personnel are employed on long-term basis, i.e. there are no short-term or temporary staff. Although the Company is somehow structured for administrative purposes (that is, it is divided into departments headed by department managers) all projects are carried out in an inter-disciplinary way. For each project, a project team is selected, grouping employees from different departments, and a Project Manager (also an employee of the Company) is appointed who is entirely and exclusively responsible for the control of the project, quite independently of the Company's hierarchy. The following is a brief statement of some facts and policies adopted by the Company. . Each employee works in some departments. An employee may possess a number of skills. . Every manager is an employee. . A department may participate in none/one/many projects. At least one department participates in a project. An employee may be engaged in none/one/many projects. consist of at least one member. Project teams Each project has specific title, deadline, and project_value Each project can have any of the following statuses: Ongoing, Terminated, Completed, And Closed. Note: Assumptions are allowed and you are allowed to include necessary columns/attributes and tables if it is required.
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