Adding column(s) to a table

[Zekii61]

Assignment : Add two new columns to a copy of the departments table, sec0611_departments. One new column, a text column, will be the name of the manager department. The other new column, a numeric column, is for the annual budget of the department.

As of right now I know how to start the code, which (if not mistaken) should look like;

alter table sec0611_departments


add column ' ______ '
add column ' ______ ';

My question is, what value do I insert in place of "name of the manager" (ex. manager_id, first_name?) and same goes for the numeric column. Price? credit_limit? budget?

[orange]

I question the assignment.

Managers come and go. Some get promoted, some get fired, now and then one quits or dies.
How would having the Managers name or id in the department table handle such an event?

Have you tried Google?
http://bit.ly/19sRY9E



Good luck.

[ItsMe]

What is preventing you from going into design view of sec0611_departments an adding the columns there?

[alansidman]

@ItsMe.

I'm guessing this is a homework "assignment" that requires the OP to add the columns using SQL

@Zekii61

Here is a good tutorial site on SQL

http://www.w3schools.com/sql/default.asp

[ItsMe]

@ItsMe.

I'm guessing this is a homework "assignment" that requires the OP to add the columns using SQL

That helps to explain why I haven't found a need to programmatically add columns to a table. I am a dropout.

[alansidman]

@ItsMe

Doesn't make any sense in Access where there is a GUI. It is something you would probably do with other db programs that don't offer GUI.