Restaurant Server Database

Restaurant Server Database

A database can start with a simple table of information to help organize a restaurant's server schedule. The creation of this data starts with the desire to organize a process such as scheduling. With this in mind, we must gather all information needed to develop a schedule. Since today we are merely speaking of how to set everything up, the demonstrated table will be short and concise with only identification numbers, first names, and last names.

To get started in our database creation, we must first create the table. This is accomplished with the "CREATE TABLE" command. On this line we will give our table a name, then select the attributes we want in our columns. Figure 1 shows the simple design of our beginners database.

[pic]fig.1

As seen here, our attributes are clearly defined as numbers no longer than 5 digits, and alphabetic names no longer than 20 letters. In addition, the "serveId" field is set as the primary key since no two servers will have the same ID, and the names are set only to not be blank. Every server will have a unique identification number, and everyone will have a name.

The next step is to enter your data values for each row. This process is completed using an insert into command. Entering this data will involve having all of the information needed to populate you database for each server. In today's example, it is merely ID number, first name, and last name as seen in figure 2.

[pic]figure 2.

With this data entered, we can now use this information as needed. With a simple select from command, we can select only the data we need to make a decision. In this example however, we will show request for all three columns be shown in order to see the full structure of our newly constructed table in figure 3.

[pic]figure 3.

Over time, as the need arises, more information will be needed to be added to this table to make informed decisions when...