The table's name should come first in bold, capital letters. Then, put the fields within a set of parenthesis. Primary key fields should be put in bold and underlined. Foreign keys should be italicized. Required fields should be placed in bold, and optional fields should use a regular font. In the example above, field1 and field2 together compose the primary key; field4 is a foreign key; and field3 is optional, while the rest of the fields are required.

You may add fields and modify field names if you wish. Choose primary key fields that are numeric, not going to change, and not more than two or three fields in length. Add a surrogate primary key field to a table if you are unable to identify a primary key. When naming a field that is not a foreign key, start with the full name or abbreviation of the table in which the field resides. When naming a foreign key, begin with the full or abbreviated name of the table it is related to. For example, consider the two tables below:

CUSTOMER ( CustID, CustFName, CustLName, CustAddress, CustPhone, CustEmail)
ORDER ( OrderID, CustID, OrderDate, OrderTotal )
ORDER_ITEM ( OrderID, ProductID, OrdItem_Qty, OrdItem_Price )
PRODUCT ( ProdID, ProdName, ProdQtyInStock, ProdPrice )

Using this naming convention, you know that in the ORDER table, every field that begins with the word "Order" is either a primary key or a normal, non-key field. You would also know that the CustID field is a foreign key that links to the primary key of theCUSTOMER table. Finally, you would know that the CustEmail field is not required, but all the others are. The consistent use of this naming convention makes it much easier to understand a database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ComputerScienceExpert

(11)

Status NEW Posted 26 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1495786645-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer