How much a Database Designer charge for making a database for a multinational companay? say for example, a company which has 2000 branches world wide?
That depends on the database, not the company it's being designed for. It will be cheaper to design a simple Access table for General Motors than to design a complex Oracle database for the local gas station. The nice thing about a well-designed database is that whether it's 2 branches or 200,000 branches, the design doesn't change. How much? Figure $50 and up per hour. How long? That depends on the database, how well you've designed the spec (discussing what you need, what you really need, how you want it done, etc., is at the same rate as actually designing it) and how many times you change what you want that means that work already done is wasted time (and your wasted money). Rough guess? Anywhere from a few hundred dollars to millions. It's not something that can be guessed at with no data to base the guess on.
We learnt Database management System in our Third Semester Course, I was wondering where it can be used, One place i found, that was In web applications Database .. like our student portal, where we login and check our results.. i though it is very useful . then i learnt my html, css, php, and made a simple portal that used database, and so on.. I asked this question because, i want to move further in Database Management System.. Is it a bright future as a Database Administrator or Database Designer ? so that i can take it with me.. Oracle, is my next choice .. i will learn that.. hopefully i will get some Free Stuff online.
Learn SQL before you learn Oracle's version of it. Learn programming before you learn SQL. You really have to learn things in order. You can't learn Shakespeare in English before you learn English, can you? Database designers make more than database administrators, but they have to know a lot more.
yes, we learned programming, in C++, algorithms and Data Structures.. We Covered, topics like 1) structures, 2) linked lists, single, double, circular 3) trees 4) queues 5) stacks, 6) hashing 7) graphs I guess, In SQL , there are Attibutes, like branch(branchno, branchname, branchstreet, branchzipcode, branchcity) can be represented in linked list as struct node { char[10] branchno; char[20] branchname; char[20] branchstreet; int branchzipcode; char[20] branchcity; node *next // This links to next tuple, in the TABLE // } Also we Learned SQL server 2008, we performed, several queries, We also Learned Entity Relational Diagrams .. and Normalization 1nf, 2nf, 3nf, BCNF
Those would be fields in a table (branch would be the table). That's in the program you use to access the database, not in SQL.
Some Teradata guys I know get paid over $100000 a year to manage the database of a large bank with a huuuuugeee data warehouse.