What are the six steps necessary to design a database for a set of requirements?

What will be an ideal response?


1.      Read the requirements, identify the entities (objects) involved, and name the entities.
2.      Identify the unique identifiers for the entities identified in step 1.
3.      Identify the attributes for all the entities.
4.      Identify the functional dependencies that exist among the attributes.
5.      Use the functional dependencies to identify the tables by placing each attribute with the attribute or minimum combination of attributes on which it is functionally dependent.
6.      Identify any relationships between tables.

Computer Science & Information Technology

You might also like to view...

For the input stream

[blank][blank] Jane Doe where will the stream buffer pointer be positioned after the following code? char ch; cin >> ch >> ch;

Computer Science & Information Technology

?A ___________ is an individual who combines strong business acumen, a deep understanding of analytics, and a healthy appreciation of the limitations of their data, tools, and techniques to deliver real improvements in decision making. 

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

What metering mode makes the most sense in a studio setting: auto, manual, aperture priority, or shutter priority?

What will be an ideal response?

Computer Science & Information Technology

Platform as a Service (PaaS)

What will be an ideal response?

Computer Science & Information Technology