I need some advice.

[slipondajimmy]

Hey everyone.

Something happened at work today. My boss pulled me into his office. I thought for sure I was being let go. I sit down and he says I hear you do programming....I said well im not sure where you heard that. I let him know Although I know some php/mysql a hardly am in a "programmer" catagory.

Well then he drops a bomb on me. He wants me to learn .net, Relational Database systems, and sql server stuff.... I let him know again that I dont know anything about the above applications. He says he would like me to give it a shot. I tell him I will but I do feel this is way above what I can do.

Let me give you a little background about my boss. He owns 2 companies. 1 is a onile retailer that does very well, and one is a company out of the country that does programs and various other things for creative labs. He can program in any language. If he dont know it he can pick up a book and be able to do it after the last page is done.

So with that being said he wants me to read a few books he provided and thnks that sometime next week I should be able to complete his first task. Here is what he wants(this is a test and will not be used for anything)...

Accounting system
Set up a database on local comp.
Set up acual database
Select/insert/Update/Delete with joins

Transaction
TransactionID
AccountID
EntityID
TypeID
ClassificationID
Amount
DateWritten
DateCleared
CheckNumber

Account
AccountID
Name
StartDate
StartAmount

AccountStatement
AccountID
DateStart
DateEnd
Deposits
Withdrawals

Entity
EntityID
Name

Classification-For if it's and expense example"Expense-Employee" or "Deposit-MErchant Account"
ClassificationID
NAme

Type-Check/Credit Card
TypeID
Name

He is offering me a substantial amount of money if I can learn this. A little more then double what im making currently. So I will give it a try, But does anyone else other then me this this is way out of my league?

Sorry for the long post. Just a little confused...lol

 

[slipondajimmy]

Yeah he was not to descriptive about that..I understand they are queries, but is it something I need to add? and if so how?

"Select/insert/Update/Delete with joins"

These would be SQL querys.

 

[Dan]

You do select, insert, etc through commands in your script or whatever it is.

 

[slipondajimmy]

Then I wonder what he meant by joins..... I know what joins are but in the same sentence...lol

You do select, insert, etc through commands in your script or whatever it is.

 

[slipondajimmy]

Hey I need some help...lol Looking at that pic can anyone tell me what should be primary keys? Im new to this and im sure its pretty basic to some. From what I understand a primary key will be something that contains unique info right?

Like account ID, Entity ID.

Once that is done How should I join this All together?