TASK1:
Implement a basic SQL database to store your company's employees and their company laptop rentals. Using SQL language, create a database with the exact name, company_database. In it, create a table called employees. Give the table a varchar column labeled name and an integer column labeled id. Then, insert a row into your new table. Give the employee any name and an id of 1.
TASK2:
Create a new table called laptops
with an integer column called id
, an integer column called employee_id
and a varchar column labeled laptop_brand
. Insert a laptop into your new table. Give it an id
of 1, an employee_id
of 1, and HP
for the laptop_brand
This is my first week of learning SQL but im unsure on how to go about this? Would be grateful if someone could help.