have you done a mysql_connect()?

And if you continue with this level of selfmotivation you aren't going to finish the year.

If you ask a specific question the people here will gladly reply. And you will get the benefit of years...

Have a look through this http://www.geekgirls.com/databases_from_scratch_1.htm

Very good intro to DB design.

Your hair's a mess and your shoes don't go with your trousers. And when DID you think that that tie went with that shirt! :)

Simple pragmatic rule.

1) He's the boss.

2) If he's wrong refer to rule 1.

Ramy,

The full range of skills needed to become a proficient Senior DBA do not appear in any book that I have read so far.

The basic skills you should have been taught during your BSc. Refine...

Ramy,

Without being facecious -
1) Remember you NEVER STOP LEARNING!
2) Buy Books on the subject and on the tools you are using. READ them all from cover to cover. Make notes in the margins and...

1) First normal form removes repeating items. http://en.wikipedia.org/wiki/First_normal_form Here the repeating items can be OwnerContact (an owner may have a number of different contact details),...

Sorry Ramy but you have some way to go before you become a fully skilled DBA. From reading your posts you have learned the fundamentals very well. You now need to get into a company position with an...

1) First Normal Form - http://en.wikipedia.org/wiki/First_normal_form
To get to FNF we have to remove the repeating fields. Current Country,Current Region,Current Site,Current Locale Start...

No Ramy, just my comments on the DB design in this thread.

I have a number of points here.
1) If each row in the EMPLOYEE_WORK table has a ROWID IDENTITY column (or similar) then you don't need the date column. INT columns are smaller that DATETIMES as...

I am making an assumption or two here, such as LOGID, your primary key, is an IDENTITY column or similar, so try this


SELECT e.logid, e.eventid, e.description, e.logtime,
l.logid, l.eventid,...

it2051229

You forgot "EXPENSIVE"

"That means you're going to read EXPENSIVE thick books."

And lots and lots of them.

And you'll need to buy them for your self because of all of the notes...

You have two options, both explained in books on line.
1) UPGRADE the server. This will upgrade your server from 2000 to 2005. It is a one way move and the whole server is changed. There is no...

Ramy,

What you have described is CLIENT / SERVER architecture. Distributed Database Program Development "sounds" like something else.

Sarah,

Please could you expand your definition of...

PHP will allow you to format the display of data in any format that you can think of.

Remember that you are taking data out of an array and placing it into holders, usually columnar but they can...

This might help.

http://uk3.php.net/manual/en/book.xml.php

I have about 6 books on PHP, all used while learning and using PHP for web development.

Two sitting at my right hand now are "SAMS - PHP5 Unleashed" (£35.99) and "Advanced PHP Programming" (36.50)...

Well now my go.

I have done something very very similar.

No you cannot have the code. It is MUCH MORE FUN it you work it out for your self.

For a start something that the previous posters...

I have never used the WAMP server. But I have installed Apache 2.2, MySQL & PHP onto an XP machine and a LINUX (debian) box. The Linux machine was a whole load easier to install. :)

Let me know if...

Now that is quite a good question.

Does the data about the stock belong (totally) to the book itself? Or is the concept of STOCK a seperate item?

The data could go in a number of places, but...

Normalization is actually fairly simple. To convert data from one form to another you apply a single, simple, rule to that data. To move to the next level of normalization apply the next rule etc....

You include ROOM_PRICE in the ROOMS table and the ROOM_TYPE table. It should only appear in one of these.

The choice is yours. ROOM gives precise control over room pricing, ROOM_TYPE gives easier...

Originally I thought that this was in the wrong forum. But I was wrong.

Your query regarding the foreign key violations should be fairly trivial if you trace back through all of the tables...

To answer a quick question, I cannot understand why you think that you need to de-normalise the data.

An ERD is (or should be) created BEFORE the database. The DB definitions are based upon the...

Let me get this straight.

You're a TECHNOPHOBE doing a DEGREE course with a large COMPUTING involvement and you want US (who are TECHNOPHILES and [mostly] have finished our degrees) to do this...

This type of question can most easily be answered by normalising the data.

Correct nomalisation will show which of these entities 'owns' the others. For instance Can a CASE have more than one...

I agree with Ramy.

The way your question is worded the only answer we can give is MAYBE. :)

I have used this style of table reuse before and always handled the releationships in the application.

As you say if you try to set foreign key relationships from either the COMPANY or CONTACT...

I don't think that you've actually asked the right question. The answer to the question that you have asked is "What ever you want to."

I think that it needs to be pointed out here that the MASTER database should NEVER be used to hold user entities. Niether sould ANY of the other SYSTEM databases (MSDB, TEMPDB).

MS often changes...

Ramy,

I tried this and it does not run.

You cannot just concatonate local variables and literals and expect them to combine into another literal.

The best that you could do is to set a char...

I can see why there is confusion about what you want from your data and precisely what is in the tables.

Possibly a different way of looking at the data could be -

SELECT...

You might like to have a look at MSSQLs MAKEWEBTASK function. Using this you can create the whole MySQL insert code for each table. It could save you the bother of having to reprocess the data from...

XML has a huge overhead in the textual naming of the entities. Also it is not meant to be humad readable, it is a transport medium. Store the data in a database, the DB overheads will be trivial...

I am sure that all programmers have had some one tell them that programming is easy because they have use access (or something) and there was no problems. Well being a DBA is much more that just...

This is going to be very difficult to do as you do not give any user requirements.

MS Access has sample templates which, I believe, provide an attendance monitoring DB and a material (asset?)...

And have a word with the company solicitor with regard to prosecuting the previous database manager under the computer misuse act.

From a SQL client point of view there is very little difference.
The management side is completely changed. The Data Transformation Service (DTS) system has been replaces by the SQL System...