Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Question

Question

Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers)

Equipments(type, requiredSkillLevel)

Workers(ID, name, daysAvailable, phoneNumber, skillLevel)

Customers(ID, name, address, phoneNumber)

Verify if the relations are normalized to BCNF, if not decompose it to BCNF.

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

A table is in BCNF if every functional dependency X → Y, X is the super key of the table.

The FDs for these given set of tables are:

ID -> name, address, phoneNumber

ID -> name, daysAvailable, phoneNumber, skillLevel

type -> requiredSkillLevel

ID, type -> customer, dayOfTheWeek, numberOfWorkers

Clearly, all the FDs satisfy the condition X → Y, X is the super key of the table. Hence, these relations are in BCNF.

Add a comment

Answer 2

Similar Homework Help Questions

For the relation schema Player (ID, Name, Birthday, Address, Email, PhoneNumber, PlayPos) assume that ID is...

For the relation schema Player (ID, Name, Birthday, Address, Email, PhoneNumber, PlayPos) assume that ID is the primary key and no Player’s names are the same (i.e., a Players’s name can uniquely identify a Player). 1. Please write down all the non-trivial functional dependencies that hold in the schema Player. 2. Please state all the candidate keys of the schema Player.
Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and p...

Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and price of job. It also maintains a file of estimates given for jobs not yet performed; this file contains a customer number, name, address, proposed date of job, and proposed price. Each file is in customer number order. Design the logic that merges the two files to produce one combined file of all customers whether past or proposed with no duplicates;...
Select the customer first name, last name, email for customers whose address district is ‘England’.Note: This...

Select the customer first name, last name, email for customers whose address district is ‘England’.Note: This will require a join between two tables. Expected Result Set Size: 7 Rows

Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...

Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes on the semantics of attributes are as follows: • Each project has a unique project ID (projID) and also has a title, type and manager. Each manager has a specialty project type. • A project often contracts jobs to contractors with start-date and end-date. Contracts are identified by contract numbers (contractNo), but contract details are out of the scope of...
Need MySql commands for Use a UNION statement. Display the address ID, address, and district from...

Need MySql commands for Use a UNION statement. Display the address ID, address, and district from the address table where the district is California or Alberta. Display the address ID, address, and district only from the address table where the address contains Jol. Display the language ID and name from the language table and the film ID from the film table. Display all languages whether they have an associated film or not. Order results by language ID in ascending order....
Transform the E-R model into a relation model Sign In Date Customer ID Service ID Sign...

Transform the E-R model into a relation model Sign In Date Customer ID Service ID Sign Name Type Service Customer Address Description Classification Pay Min Monthly Charge Consumed Units Per Month Rate Per Unit Due Date Pay Date

Customer Transaction Table – CUSTOMER_TXNS Column Name Description Type Account_id Account identifier Integer Txn_timestamp Time of...

Customer Transaction Table – CUSTOMER_TXNS Column Name Description Type Account_id Account identifier Integer Txn_timestamp Time of transaction (UTC) Timestamp Product_id The id of the product purchased Integer Txn_Amt The revenue amount of the transaction Float Txn_Qty The number of items purchased Integer NOTE: Customer Transaction table has multiple records per account_id. Customer Master Table – CUSTOMER_MSTR Column Name Description Type Account_id Account identifier Integer Country Country Code Character(3) Address Address of the customer Character(64) Registerd_Dt Date the account id was...
JAVA Write code to define a Customer class, which has id and name attributes of String...

JAVA Write code to define a Customer class, which has id and name attributes of String data type and points attribute of integer data type, without breaking encapsulation.
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type,...

EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 . Show: order id, lastname, and total-amount . Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total...

Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer...

Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer Refers State City City Address Address State Zip Code Street Holds Zip Code Merchant Card Type AccountID Card Account Has Exp Date Charge Date Charge Time Card Type = "C Debit Card Credit Card Has Charges Current Balance Bank No. Amount

Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Homework Answers

Add Answer to:
Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Post as a guest

Earn Coins

For the relation schema Player (ID, Name, Birthday, Address, Email, PhoneNumber, PlayPos) assume that ID is...

Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and p...

Select the customer first name, last name, email for customers whose address district is ‘England’.Note: This...

Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...

Need MySql commands for Use a UNION statement. Display the address ID, address, and district from...

Transform the E-R model into a relation model Sign In Date Customer ID Service ID Sign...

Customer Transaction Table – CUSTOMER_TXNS Column Name Description Type Account_id Account identifier Integer Txn_timestamp Time of...

JAVA Write code to define a Customer class, which has id and name attributes of String...

EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type,...

Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer...

Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Homework Answers

Add Answer to: Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...

Post as a guest

Earn Coins

Add Answer to:
Jobs(ID, type, customer, dayOfTheWeek, numbersOfWorkers) Equipments(type, requiredSkillLevel) Workers(ID, name, daysAvailable, phoneNumber, skillLevel) Customers(ID, name, address, phoneNumber)...