And the promotions the company provides for books
Table 1.1 JustLee Books Tables Description
|
|
|
|
|
|
1. Run the queries in the JLDB_Build.sql to create and populate the tables for JustLee
Books database. For each created table, display the table’s structure using the
characters, and the CatDesc column should store a maximum of 10 characters.
3. Create a new table containing these four columns: Emp#, Lastname, Firstname, and
consider suitable for the Firstname and Lastname columns.
4. Add two columns to the EMPLOYEES table. One column, named EmpDate, contains
6. Delete the EndDate column from the EMPLOYEES table.
7. Rename the EMPLOYEES table as JL_EMPS.
1.If the needed command is not given in the slide Google them!!
2.If, while executing the script file, you encounter any error, observe the error and make necessary correction(s) to the statement.