The column characteristics for these tables are shown in Figures 1-28 (DEPARTMENT), 1-30 (EMPLOYEE), 2-42 (PROJECT), and 2-44 (ASSIGNMENT). The data for these tables are shown in Figures 1-29 (DEPARTMENT), 1-31 (EMPLOYEE), 2-43 (PROJECT), and 2-45 (ASSIGNMENT). If at all possible, you should run your SQL solutions to the following questions against an actual database. Because we have already created this database in Microsoft Access, you should use an SQL-oriented DBMS such as Microsoft SQL Server 2014, Oracle Database, or MySQL 5.6 in these exercises. Create a database named WPC, and create a folder in your My Documents folder to save and store the *.SQL scripts containing the SQL statements that you are asked to create in the remaining questions pertaining to the WPC database in this section and the following Project Questions section.
■ For the SQL Server Management Studio, create a folder named WPC-Database in the Projects folder structure in your SQL Server Management Studio folder.
■ In the Oracle SQL Developer folder structure in your SQL Developer folder, create a folder named WPC-Database.
■ For the MySQL Workbench, create a folder named WPC-Database in the Schemas folder in your MySQL Workbench folder.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here