Blog

Use the Entity below. Write the SQL CREATE Table query.    

What was the most challenging part of the ITD 256 course?

You have a table named ‘Employee’. Write a SQL statement to modify the table to add an “Email” column to the table.

Many-to-Many You have a many-to-many relationship between RECIPE and INGREDIENT. You will need to create an appropriate bridge/linking entity to breakdown the relationship.  “Each Recipe can have many Ingredients” “Each Ingredient can be used in many Recipes” Respond to 1 and 2 1) Write a bridge/linking entity that could be used to create a one to many relationship on both sides. You do not need to draw it. Just write the name in all capital letters. Your choice of what entity(table) you think would best link in order to make sense. Don’t overthink it. 2) Write the relationship statements similar to above but include your new entity. 

In a SQL statement, the OR operator displays a record if any of the conditions are TRUE.

SQL Statements Use the sample data in the table to create the appropriate SQL statement. Employee Table Respond to #1 below. 1) Write a SQL Query to list the employee(s), whose salary is the highest. 2) Write the ename(s) and salary figure(s) that will return in the query.  

There are different types of SQL Joins. Which join is defined as ‘Returns only rows with matching values in both tables’?

How does the organization of data in a table structure relate to normalization?

A patient completes a pulmonary function test. The patient’s forced vital capacity (FVC) is the total amount of air forcibly exhaled after a maximal inspiration, while the forced expiratory volume (FEV) measures

A patient has persistently low blood pressure due to severe blood loss. Which hormone would be released first as part of the renin-angiotensin-aldosterone system (RAAS)?