Answered step by step
Verified Expert Solution
Link Copied!

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


2021-12-03 (69).png


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:

 

0_-lCFh62mIGR_074B.png  

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Databases questions