Relational database is to be designed for a medium sized

Assignment Help Database Management System

Reference no: EM132685159

Read and analyse the following specification of a sample database domain.

Task 1 Read and analyse the following specification of a sample database domain. A relational database is to be designed for a medium sized Company dealing with industrial applications of computers. The Company delivers various products to its customers ranging from a ("Simple') single application program through to ("Complex') complete installation of hardware with customized software. 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 company assigns a Consultant and a Sales-coordinator who is an expert in the field to Simple Products projects. The company assigns Project Manager and a Consultant and a number of expert and supporting staff to a Complex Project. Complex projects have a budget assign to the project manager. Simple products do not have a budget. An expert can work in multiple roles (project manager, expert, sales coordinator etc).

An objective if this task is to construct a conceptual schema for the specification of a database domain listed above.

It is not allowed to add any artificial identification attributes commonly known as "id" attributes to the specification listed above.

Reference no: EM132685159

Questions Cloud

Identify what you thought was the most important concept : Identify what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding

Debt-to-equity ratio of national grid : The debt-to-equity ratio of National Grid (which owns the high-voltage electricity transmission network in the UK and in New England) was around 1.9 in 2014. St

How do explain the functional currency for lucky trader ltd : How do Discuss the transaction date as per the case study and indicate the rate that will be used to translate the purchased inventory to N$. 6.

Determine the balance in the allowance for uncollectible : StorageTek Corporation, Determine the balance in the Allowance for Uncollectible Accounts account after the adjusting entry is recorded

Relational database is to be designed for a medium sized : The company assigns Project Manager and a Consultant and a number of expert and supporting staff to a Complex Project

Do think that recognize as sales revenue is correct : Your client Corp A is a company engaged in the production of heavy equipment, Do think that recognize it as sales revenue is correct? Explain your answer!

What ratio would calculate : If you wanted to perform an analytical procedure to check the suspected occurrence of this double counting scheme, what ratio would you calculate?

Identify court cases that have shaped the evolution : Identify court cases that have shaped the evolution of the public policies related to your chosen public policy issue, justifying your identifications.

What account should the client classify the apartment : In your opinion, as an auditor, what account should the client classify the apartment and housing / real estate complex be? Explain your answer.

User Account

All Pages