One simple request - Clarification

[shani20]

I know most of you probably will roll your eyes. However, since most of you are expert at what you are doing, I assume you'd understand what my instructor is trying to get us to do something that I quite dlon't understand what I am supposed to do.

The assignment that I have to do is - create a spreadsheet (excel), and define columns with the following headings (primary key, name of column, Null, Dataype, Decription, Foreign Key, Foreign Key Table) this part I know wha tI am supposed to do.



Each row will contain your rows for *this* table - what is the heck table? I have 6 tables and I am assuming that I have to do this for EACH table.

Fill out the column row-wise.

Can you help me out with this and just give me an example of what the instructor is trying to make me to do.

Thank you

Shani

[June7]

I will take a guess they want you to use a spreadsheet (instead of pen and paper) to plan the table structure. Example:

tblCustomers

Primary Key	Field Name	Null	DataType	Description	Foreign Key	Foreign Key Table
Yes	CustID	No	autonumber	unique record identifier	No	NA
No	LastName	No	text	customer last name	No	NA
No	FirstName	No	text	customer first name	No	NA
No	Address	Yes	text	customer billing address	No	NA
No	Email	Yes	text	customer email address	No	NA

tblOrders

Primary Key	Field Name	Null	DataType	Description	Foreign Key	Foreign Key Table
Yes	OrderID	No	autonumber	unique record identifier	No	NA
No	Customer	No	number (long)	ID of customer placing order	Yes	tblCustomers
No	OrderDate	No	Date/Time	date of order	No	NA

[shani20]

Yes - the instructor was not clear when I emailed him about the homework question. I explained that I have completed all assignments except for this part which I was not sure what he's trying to convey. But the solution that you proposed was the same that I have drafted up so I'm all good

Thanks!!!

Shannon