After concluding the discovery phase of database design, Don began brainstorming about the tables he

After concluding the discovery phase of database design, Don
began brainstorming about the tables he needs to create and which specific
fields within those tables are necessary to capture all data required for the
desired output he identified. Don created tblEmployee. He asks you to create
the table designs for the remaining tables in the database by grouping the
existing and missing data he identified into tables, creating field names and
data types, and naming the fields and tables according to the standards he
established.

On a piece of paper, complete the following:

1. Plan the
»

After concluding the discovery phase of database design, Don
began brainstorming about the tables he needs to create and which specific
fields within those tables are necessary to capture all data required for the
desired output he identified. Don created tblEmployee. He asks you to create
the table designs for the remaining tables in the database by grouping the
existing and missing data he identified into tables, creating field names and
data types, and naming the fields and tables according to the standards he
established.

On a piece of paper, complete the following:

1. Plan the Employee and Customer tables needed in the
4Corners Pharmacy database using the information Don garnered during the
discovery phase. Planning each table in this database will be a time-consuming
process. After you complete these two tables, challenge yourself to plan other
tables.

2. Name the Employee and Customer tables according to their
contents and the Leszynski/Reddick naming conventions.

3. List the fields in each table.

 4. Designate data types for each field in each table.

5. Look at the plan you created for 4Corners Pharmacy and
look for any missing or incomplete data. What other changes would you suggest
making, and why?

»