Question: How would you identify attributes from a users requirements specification and then associate the attributes with entity or relationship types?

How would you identify attributes from a user’s requirements specification and then associate the attributes with entity or relationship types?

Step by Step Solution

★★★★★

3.33 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

In a similar way to identifying entities we look for nouns or noun phrases in the users requirements ... View full answer

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

Document Format (1 attachment)

Word file Icon

672-CS-DB (1382).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

How would you identify entity and relationship types from a users requirements specification?

Q:

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...

Q:

Virtual Campus (VC) is a social media firm that specializes in creating virtual meeting places for students, faculty, staff, and others associated with different college campuses. VC was started as a...

Q:

1. Answer the following two questions. a. Identify and describe two types of facility you would expect to be provided in a multi-user DBMS. Identify two types of facility that not be needed in a...

Q:

Project Description/Background NU Hospital Mission statement: The purpose of the NU Hospital database application is to maintain the data that we generate and to provide an efficient, effective, and...

Q:

Project Description/Background NU Hospital Mission statement: The purpose of the NU Hospital database application is to maintain the data that we generate and to provide an efficient, effective, and...

Q:

Project Description/Background NU Hospital Mission statement: The purpose of the NU Hospital database application is to maintain the data that we generate and to provide an efficient, effective, and...

Q:

A many to many relationship between two entities usually in how many tables? Three Four Five Two An ______ is a set of entities of the same type that share the same properties, or attributes. Entity...

Q:

1. Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people? a. What is the difference between a homogeneous and a...

Q:

what is non-volatile. 5.How would you identify entity and relationship types from a user's requirements specification? a. Discuss why you would want to validate a conceptual data model and describe...

Q:

Both Alan Greenspan and Ben Bernanke have claimed that monetary policy was not responsible for the housing bubble. Instead, they blame a change in the relationship between short-term interest rates...

Q:

Margaux de Chien, a naturalized U.S. citizen, was born in France. She went to work for Vin Enterprises, a wholly owned subsidiary of a Delaware corporation licensed to do business in Colorado. The...

Q:

2. LO.1 Why are certain organizations either partially or completely exempt from Federal income tax?

Q:

What were some of the factors that were believed to have contributed to the aforementioned asset bubble?

Q:

Explain why it would be preferable to use a DATE data type to store date data instead of a character data type.

Q:

Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate...

Q:

The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands...

Q:

A population consists of the following five values: 10, 10, 38, 37, 13. b. By listing all samples of size 3, compute the mean of the distribution of the sample mean and the population mean. Compare...

Q:

A Mesophilic bacterium A utilizes glucose to produce an intracellular protein B and an extracellular byproduct C. The aerobic bacterium is metabolically active in the pH range of 6.9 7.2. A...

Q:

Consider a no-load mutual fund with $247 million in assets, 15 million shares and $36 million in debt at the start of the year. It invests in a portfolio that provides no income but increases price...