ABC Consulting IT company specialises on Mobile Application development for businesses. The company needs a database...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ABC Consulting IT company specialises on Mobile Application development for businesses. The company needs a database to store information about projects and employees working on the projects. You task is to design a relational database and create SQL queries to create and populate the tables. The database requirements contain the following information: . . Employees working on the projects are divided into two categories: Developers and Development Managers Developers are working in Teams Each Development Manager manages at least one Team. Each Team works on at least one Project. At least one Team works on a Project The following general information is stored for each Employee: ID, Name and The Developer additional attributes are Position and Skill (not multi-valued). Part 1. Conceptual Model Please remember that the Enhanced Entity Relationship diagram is only a part of your assignment. You need to describe the Conceptual Model, which must include the following elements: The Development Manager additional attribute is a Product Type. The Teams attributes are Team ID, team name and team start date. One of the team members (Developers) is also a team leader. This information must also be stored in the database. The Project attributes are Project ID, Project Name Start Date and End Date. HoursWorked is an association between Project and Developer, and it is a number of hours a Developer spent working on a Project. . Entities and their attributes For each entity you must also specify unique identifier attribute(s) Entity supertypes and subtypes. Describe inbormance types and the corresponding discriminators Identify multi-valued and composite attributes (if way). In this case, they need to be shown in the ER diagram with the corresponding notations. Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, ong-lo- many, many-to-many, and also optional o mandatory Draw the Conceptual Model Enhanced Entity-Relationship diagram using app diagrams net tool, save it as png, or jpg file and insert it in the Word document Part 2. Logical Model Describe the algorithm of convert the Conceptual Model into the Logical Model Remember that your description should include the following elements S Entities in the Conceptual Model become relations (tables) in the Logical Mocel, and unique identifiers become primary keys For one-to-one or one-to-many relationship between two entities you will need to create a foreign key in one of the relations (lables) If there is a many-to-many relationship between two entities, then you will need to create a new relation (table) with a composite primary key For each field (column) in a relation, describe a data typa (integec Boat, character, text etc.) If an entity contains a multi-valued attribute, then you will need to create a new relation in the Logical Model corresponding to this attribute ABC Consulting IT company specialises on Mobile Application development for businesses. The company needs a database to store information about projects and employees working on the projects. You task is to design a relational database and create SQL queries to create and populate the tables. The database requirements contain the following information: . . Employees working on the projects are divided into two categories: Developers and Development Managers Developers are working in Teams Each Development Manager manages at least one Team. Each Team works on at least one Project. At least one Team works on a Project The following general information is stored for each Employee: ID, Name and The Developer additional attributes are Position and Skill (not multi-valued). Part 1. Conceptual Model Please remember that the Enhanced Entity Relationship diagram is only a part of your assignment. You need to describe the Conceptual Model, which must include the following elements: The Development Manager additional attribute is a Product Type. The Teams attributes are Team ID, team name and team start date. One of the team members (Developers) is also a team leader. This information must also be stored in the database. The Project attributes are Project ID, Project Name Start Date and End Date. HoursWorked is an association between Project and Developer, and it is a number of hours a Developer spent working on a Project. . Entities and their attributes For each entity you must also specify unique identifier attribute(s) Entity supertypes and subtypes. Describe inbormance types and the corresponding discriminators Identify multi-valued and composite attributes (if way). In this case, they need to be shown in the ER diagram with the corresponding notations. Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, ong-lo- many, many-to-many, and also optional o mandatory Draw the Conceptual Model Enhanced Entity-Relationship diagram using app diagrams net tool, save it as png, or jpg file and insert it in the Word document Part 2. Logical Model Describe the algorithm of convert the Conceptual Model into the Logical Model Remember that your description should include the following elements S Entities in the Conceptual Model become relations (tables) in the Logical Mocel, and unique identifiers become primary keys For one-to-one or one-to-many relationship between two entities you will need to create a foreign key in one of the relations (lables) If there is a many-to-many relationship between two entities, then you will need to create a new relation (table) with a composite primary key For each field (column) in a relation, describe a data typa (integec Boat, character, text etc.) If an entity contains a multi-valued attribute, then you will need to create a new relation in the Logical Model corresponding to this attribute
Expert Answer:
Related Book For
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these databases questions
-
Consider someone you know whom you regard as an exceptionally good person. How much does this person resemble Platos portrait of the just person? How is he or she different?
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Sound waves with frequency 3000 Hz and speed 343 m/s diffract through the rectangular opening of a speaker cabinet and into a large auditorium of length d = 100 m. The opening, which has a horizontal...
-
We have simplified things here by separating friction (Sec. 9.7) from heat addition (Sec. 9.8). Actually, they often occur together, and their effects must be evaluated simultaneously. Show that, for...
-
Find all matrices X and Y such that: 2X - 5Y = [1 2]
-
Determine the total bare-module cost for the flowsheet in Figure 16.21 at ambient temperature and pressure. Use \(\mathrm{CE}=600\). Design Specifications Pumps: reciprocating, motor driven, 25 psia...
-
A few years ago, there was a large oil refining company (based in New York) whose top executive was convicted of financial statement fraud. One of the issues in the case involved the way the company...
-
Describe some of the advantages & disadvantages of remote work arrangements. Give a personal example of someone you know or know of (including yourself if applicable) who works remotely, or who...
-
Allen Blay owns 100% of the stock in AB Corporation, organized ten years ago in California. AB operates a foreign branch in Country A. In the current yea r, AB reports $500,000 of taxable income from...
-
You are a healthcare administrator reviewing statistics on lab tests ordered and realize that a few physicians account for the majority of orders of a certain very expensive lab test. You do a bit of...
-
Suppose you take a 3 / 1 interest - only, 3 0 - year ARM for $ 1 8 0 , 0 0 0 . 0 0 with an interest - only contract rate of 3 % and a following rate of 7 . 7 5 % in year four. Assume you pay 1 . 5...
-
A company is producing a premium chocolate cake to be distributed to supermarkets and restaurants. The sales price for each cake is $ 3 5 , the variable costs per unit is $ 7 . 5 0 , total annual...
-
The following results for a set of data is given for a polynomial regression: p4 p2 p3 P p5 p6 +36 +6.2 3 +3.1 9 x P2 +3.1 y: 2.9 +1.1 XP + 1.4 +1.8 +2.2 First, re-write the table with numerical...
-
Please describe and elaborate with as much words as possible addressing the issues of human rights and/or environmental sustainability as they are exacerbated by business from your point of view as a...
-
Following is a trial balance of City of Jeddah's General Fund at December 3 1 , 2 0 2 2 . Prepare: ( a ) a statement of revenues, expenditures, and changes in fund balance for the year ended...
-
In an attempt to estimate the speed of a vehicle just before it hit a signal pole, a traffic engineer measured the length of the skid maills made by the vehide and performed trial. runs at the site...
-
A new car sold for $31,000. If the vehicle loses 15% of its value each year, how much will it be worth after 10 years?
-
What additional information would you like to have in order to assess performance on the project?
-
Have you ever used bets to motivate someone? How effective was it?
-
The Munsters have been saving money in order to buy a house. They figure that, given current interest rates, they could afford a $400,000 home. Before looking at houses on the market they decide to...
-
A construction engineer has to inspect 5 construction sites in a 2-day inspection schedule. He may or may not be able to visit these sites in two days. He will not visit any site more than once. (a)...
-
An explosion in an LNG storage tank in the process of being repaired could have occurred as the result of static electricity, malfunctioning electrical equipment, an open flame in contact with the...
-
What conditions for the binomial distribution, if any, fail to hold in the following situations? (a) For each of a company's eight production facilities, record whether or not there was an accident...
Study smarter with the SolutionInn App