Need to verify my solution for 2 MySql Oracle questions ASAP in 2 hrs
Budget: $10 – $20 CAD
Write the commands following the instructions below.
1.Create a table called WRITERS that contains the author ID, last name, first name, and the ISBN and title of the book each author wrote. Use the same data types as the corresponding columns in the AUTHOR and BOOKS table. Do not copy the data from these tables, however. Include the following constraints:
the author ID is the primary key;
the title is not null;
the ISBN is a foreign key referencing the ISBN in the books table.
2.In the table creation assignment you created a table called EMPLOYEES. Alter this table so that the SSN is the primary key
1.Create a table called WRITERS that contains the author ID, last name, first name, and the ISBN and title of the book each author wrote. Use the same data types as the corresponding columns in the AUTHOR and BOOKS table. Do not copy the data from these tables, however. Include the following constraints:
the author ID is the primary key;
the title is not null;
the ISBN is a foreign key referencing the ISBN in the books table.
2.In the table creation assignment you created a table called EMPLOYEES. Alter this table so that the SSN is the primary key