Question : Design an Entity - Relationship Diagram (ERD) and map the entities with appropriate relationships
Fantastic news! We've Found the answer you've been seeking!
Question:
Question :
Design an Entity - Relationship Diagram (ERD) and map the entities with appropriate relationships
- Output
- Brief explanation on the diagram
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these databases questions
-
Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...
-
Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...
-
The following items were shown on the balance sheet of Martin Corporation on December 31, 2021: Stockholders' Equity Paid-In Capital Capital Stock Common stock, $5 par value, 750,000 shares...
-
Write an equation for the reaction of CH2=CHCH2CH3 with each of the following reagents: a. Hydrogen chloride b. bromine c. Hydrogen (Pt catalyst) d. H2O, H+ e. Ozone, followed by H1 f. KMnO4, OH g....
-
A Rankine steam power plant produces 0.5 MW of mechanical power by expanding steam from 60 bar, 700 C, to 3 bar. The efficiency of the turbine and of the pump is 80%. Calculate the energy balances,...
-
How is the sales volume in dollars necessary to reach a target profit calculated? a. target profit unit contribution margin b. target profit contribution margin ratio c. (fixed expenses + target...
-
1. Do the notes to the nancial statements indicate the component units and other related entities that are included within the reporting entity? Do they indicate any units that are not included? Do...
-
Malimali Fish Products Ltd, A Malindi-based firm dealing in fish products, conducts training programmes for all its line managers. The managers ar expected to master, in particular, procedures in...
-
On January 1, 2036, Cp9-15T Company acquired the following investments: 1. 6,820 shares (representing 18%) of BG-8Yt Company stock for $98,000 2. 42,200 shares (representing 47%) of Ix-7n Company...
-
If f(x) == 16x+3, find the slope of the secant line between the values of 1 = - - 8 and 2 = 8.
-
John agrees to buy a second-hand fishing boat from Malcolm. They agree the price of $20,000 and John pays a deposit of $2,000. He arranges to collect the boat the next day when he has his ute with...
-
would like to develop a manual to Innovative Insurancethat includes an introduction which educates prospective customers about the function/purpose of insurance. How write a memo answering this...
-
What particular legal issue arises as a result of electronic transmission of a bill of lading? Why is this knowledge important to international traders negotiating documentary credit transactions
-
In Donna Dubinsky and Apple Computer, Inc. case, how do we make sense of how she responded to Jobs' efforts to implement a JIT system without including her relating to immunity system, power and...
-
Information systems are a major part of todays world. There are a number of aspects to information system analysis and design which must be considered in order to build a useful system. One of these...
-
Huntingdon Capital Corp. is a competitor of Plazacorp and First Capital Realty. Huntingdon reported the following selected information (in millions):...
-
Consider absence from work as an example of organizational behaviour. What are some of the factors that might predict who is likely to be absent from work? How might you explain absence from work?...
-
Do you think that organizations should base their hiring decisions on applicants personalities? What are the advantages and disadvantages of doing this? If an organization were to do this, what...
-
Use the contingency approach to describe a task or an organizational department where a more classical management style might be effective. Then do the same for a task or department where the human...
Study smarter with the SolutionInn App