Edit your submission in this Word document, attaching the screenshots of the codes used for each question. Include narrative descriptions, outputs screenshots, or short answers when requested.

Transcribed Image Text:

[Task 1 We have a table below: branchNo branchAddress 8 Jefferson Way, Portland, OR 97201 telNos 503-555-3618, 503-555-2727, 503-555-6534 206-555-6756, 206-555-8836 B001 B002 City Center Plaza, Seattle, WA 98122 B003 B004 16-14th Avenue, Seattle, WA 98128 206-555-3131, 206-555-4112 14-8th Avenue, New York, NY 10012 212-371-3000 Please answer the following questions: 1. What is the normal form of the table? Please answer by describing the functional dependency in the table. 2. Normalize the table to 3NF. You may use word document table, or figures generated from other software. 3. Identify the primary keys and foreign keys in the 3NF relational schema. Task 2 We have a table below: staffNo branchNo branch Address name S4555 B002 S4555 B004 S4612 B002 S4612 B004 City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 Dave Sinclair position Ellen Layman Assistant 16 Ellen Layman Assistant 9 Dave Sinclair Assistant 14 hoursPerWeek Assistant 10 Please answer the following questions: 1. What is the normal form of the table? Please explain by describing the functional dependency in the table. 2. List all the logical functional dependency, such as "name [Task 1 We have a table below: branchNo branchAddress 8 Jefferson Way, Portland, OR 97201 telNos 503-555-3618, 503-555-2727, 503-555-6534 206-555-6756, 206-555-8836 B001 B002 City Center Plaza, Seattle, WA 98122 B003 B004 16-14th Avenue, Seattle, WA 98128 206-555-3131, 206-555-4112 14-8th Avenue, New York, NY 10012 212-371-3000 Please answer the following questions: 1. What is the normal form of the table? Please answer by describing the functional dependency in the table. 2. Normalize the table to 3NF. You may use word document table, or figures generated from other software. 3. Identify the primary keys and foreign keys in the 3NF relational schema. Task 2 We have a table below: staffNo branchNo branch Address name S4555 B002 S4555 B004 S4612 B002 S4612 B004 City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 Dave Sinclair position Ellen Layman Assistant 16 Ellen Layman Assistant 9 Dave Sinclair Assistant 14 hoursPerWeek Assistant 10 Please answer the following questions: 1. What is the normal form of the table? Please explain by describing the functional dependency in the table. 2. List all the logical functional dependency, such as "name