A word of caution: While the keywords are not case sensitive, the string values that are stored as data in a table do preserve case, as you would expect. Keep this in mind when doing string comparisons in queries. Putting It Into Perspective: Schema And Catalog Though you can stick all of your data into a single table, it doesn t make sense logically to do this all the time. For example, in our EMPLOYEE table shown previously, we could add information about company departments; however, the purpose of the EMPLOYEE table is to store data on the employees. The solution is for us to create another table, called DEPARTMENT, which will contain information about the specific departments in the company. To associate an employee with a department, we can simply add a column to the EMPLOYEE table that contains the department name or number. Now that we have employees and departments neatly contained, we can add another table, called PROJECT, to keep track of the projects each employee is involved in. Figure 2.2 shows our tables. Figure 2.2 The EMPLOYEE, DEPARTMENT, and PROJECT tables track employees by department and project. Now that you understand how to logically separate your data, it s time to take our model one step higher and introduce you to the schema/catalog relationship. The schema is a higher-level container that is defined as a collection of zero or more tables, where a table belongs to exactly one schema. In the same way, a catalog can contain zero or more schemas. This abstract is a necessary part of a robust relational database management system (RDBMS). The primary reason is access control: It facilitates who can read a table, who can change a table, and even who can create or destroy tables. Figure 2.3 demonstrates this point nicely. Here we have added another table, called CONFIDENTIAL. It contains the home address, home phone number, and salary of each employee. This information needs to belong in a separate schema so that anyone who is not in payroll cannot access the data, while allowing those in marketing to get the necessary data to do their job. Figure 2.3 The table, schema, and catalog relationship allows you to limit access to confidential information.
If you are looking quality, fast, secure and reliable web hosting with PHP service at an affordable price, check php5 hosting services.