Question: Map the following medium-size software vendor data model into a relational database design. You are required to specify tables, primary keys, and foreign keys. Use

Map the following medium-size software vendor data model into a relational database design. You are required to specify tables, primary keys, and foreign keys.

Use the following format for the tables/relations

TABLE_NAME (column_name1, column_bame2, , column_namen)

Underline Primary Keys, and Italicized Foreign Keys

Example: TASK (TaskCode, Description, Type, Status, ListID)

COUNTRY CountryID CountryName EMPLOYEE Employeeld Name Address Phone COUNTRY_MANAGER Employeel Rank Manages DEVELOPER Employee Certificate ASSIGNMENT Employeeld ProjectID Score Hours Rate MEMBERSHIP Employeeld TeamID Joined Left PROJET ProjectID TEAM TeamID Is Responsible for TeamName + StartDate EndDate StartDate EndDate +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Map the following medium-size software vendor data model into a relational database design. You are required to specify tables, primary keys, and foreign keys. COUNTRY CountrylD CountryName EMPLOYEE...

Hi, I need only part 5 of this question. I need to MS Access file with all running queries for part 5. D3: DB Specification & Implementation : After you have developed the conceptual E-R model for...

D3: DB Specification & Implementation : After you have developed the conceptual E-R model for GG, convert that data model into a relational database design for Garden Glory. Then develop the...

2. You are asked to develop a database for microcomputer lab management. You want to keep track of the following information (Type your answer): The information about computer such as station ID,...

QUESTION 1 In a table containing data about people, the property "First Name" would be an example of: 1. A Row 2. A Table 3. A Database 4. A Column QUESTION 2 A many to many relationship in the...

The problem scenario You are asked to design a database for a company that operates driving schools at several cities in your home city. It is to store information about the driving schools, clients,...

After you have reviewed the E-R model, create a relational database design for the model. 1. For each entity in the E-R model, specify a table structure, determine the data types and additional...

Anyone can help ? thanks . Question 1: [Handwritten or Computer Processed] The following scenario outlines a set of data relationships. Please construct a UML diagram that describes the relationships...

Find the following percentiles for an F distribution with the following specifications: a. = .05, df1 = 14, df2 = 9 b. = .025, df1 = 39, df2 = 27 c. = .01, df1 = 50, df2 = 39 d. = .10, df1 = 39,...

Let A be an n x n matrix and let Q and V be n n orthogonal matrices. Show that (a) ||QA||2 = ||A||2 (b) ||AV||2 = ||A||2 (c) ||QAV||2 = ||A||2

The three components of the Treasury yield curve include the real rate, expected future - - , and the interest rate risk premium.

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

4. Trust develops with shared experience, values, give-and-take, and the result of human communication. Satellites, electronic mail, and networks could reduce the dimensions of trust to which we are...

3. Messages of affect and value will decrease. Ambiguity in interpreting information will increase. Managers will have to seek new ways of communicating the affective component of messages.

5. The computer imposes a discipline of linear thinking. Organizations will need to find ways to encourage and protect nonlinear thinking and communicating.