Define the concept of entity integrity. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. Define the concept of referential integrity. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key  Create an ERD based on the Crow’s Foot model, using the database tables in Figure 1. Show the relationship's strength (weak or strong)

Q: Which of the following is false: A. Tables are joined by using primary key/foreign key combinations…

A: The following statement is false B. A primary key can consist of more than one attribute

Q: 1. Create 1-NF Normalization and define repeating groups 2. Create 2-NF Normalization and define…

A: Since multiple staff ID and staffName exist with single report, hence in 1NF, we need to seperate…

Q: Attributes of ENTRY TRANSACTION : Id_Transaksi_entry, Reservation, Date_Checkin, Id_Guest, NIP…

A: Name_employee, NIP FROM EMPLOYEES WHERE NIP NOT IN (SELECT NIP FROM ENTRY_TRANSACTION) AND NIP…

Q: Task:Let us consider the following relational database. The primary key column(s) of each table is…

A: Tables created with dummy variables to test the codes.Demo results:Task 1:Task 2:Task 3:Task 4:Task…

Q: that consists of five tables. Primary keys are (BOLD and Italicized). Attributes with the same names…

A:

Q: Convert the diagram into a set of relational tables. The tables must be in 3NF. All referential…

A: Relational Tables: 1. Customer(CustomerID (PK),firstName, LastName, emailAddress, phoneNumber,…

Q: Consider the following relations for a database that keeps track of orders: orderLines(lineNumber,…

A: Foreign key: A foreign key is a column or more than one column in one table that refers to the…

Q: have 3), 5(2 (A, E) and the size (i.e., the number of rows) of each relation is as follows: TR =…

A: Dynamic programming is a technique in computer programming that helps to efficiently solve a class…

Q: What are the 3 situations that suggests relations be denormalized before database implementation

A: Normalized relations are turned into non-normalized requirements mostly during denormalization…

Q: Consider the employee database of Figure 3.19. Give an expression in SQL foreach of the following…

A: Query: Give all managers of “First Bank Corporation” a 10-percent raise. SQL expression: UPDATE…

Q: Using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients,…

A: The Set of entities provided for Colonial Adventure Tours Database includes Trips, Guides, Clients…

Q: Consider the Student database schema given below. 1. Write SQL to Retrieve student id's and student…

A: The tables student and enrolled created and inserted data  The table student is: Table enrolled is:…

Q: Task:Let us consider the following relational database. The primary key column(s) of each table is…

A: Tables created with dummy variables to test the codes.Demo results:

Q: Consider the following relational database schema that contains information about employees and…

A: {pid,pname} {pid,pname,budget} {pname,managerid} {pname,budget,managerid}

Q: Consider the database schema below and answer the questions that follow using SQL.…

A: 1. Retrieve all employees in “sales department” whose salary is between Ksh 30,000 and Ksh…