Reference no: EM13839206
Problem 1: For each table below, perform the following 3 steps. (Perform all three steps on Table A first. Then perform all 3 steps on Table B).
Step 1: Determine if the table satisfies 2NF. If the table is already in 2NF, say so. If a table violates 2NF, say so and produce the 2NF tables. It is sufficient to just list the results of 2NF normalization.
Step 2: Determine if all resulting tables from Step 1 satisfy BCNF. For each of the resulting tables from Step 1, if it is already in BCNF, say so.If it violates BCNF, say so and produce the BCNF tables. It is sufficient to just list the results of BCNF normalization. There is NO need todescribe the normalization process verbally.
Step 3: Check and make sure every table you wrote in Steps 1 and 2 has a primary key specified. If not, specify the primary key for each table missing the primary key.
Points will be deducted if a table you write does not have a PK specified.
A. Sale: (Date, Customer#, Product#, Vendor#, Vendor-City, SalesRepName)
Additional FD: Customer#→ SalesRepName; Vendor#→Vendor-City
B. BookInfo: (BookTitle, Print#, DateofPrint, #copiesPrinted, #copiesSold, Price, MajorSponsorName, MajorSponsorPhone )
Additional FD: MajorSponsorName →MajorSponsorPhone
Problem 2: Determine if each of the following tables satisfy BCNF. If the table is already in BCNF, say so. If the table violates BCNF, say so and produce the BCNF tables. It is sufficient to just list the results of BCNF. There is NO Need to provide the normalization process. Do not go normalize it to 2NF first. Normalize each table to BCNF directly. The primary key and additional functional dependencies are already given. Do not assume further function dependencies. Be sure to identify the primary key for each table you write
Fundraising: (Event#,SubEvent, Date, OrganizerName, OrganizerPhone, Beneficiary)
Additional FDs: Event# → Date, OrganizerName
OrganizerName → OrganizerPhone
FileDownload: (SessionId,DownLoadId, FileName, SessionStDateTime, SessionEndDateTime, FileSize, FileType)
Additional FDs: SessionId → SessionStDateTime, SessionEndDateTime
FileName → FileSize, FileType
|
Calculate the load that a fibroblast cell applies
: Calculate the load that a fibroblast cell applies to buckle a simple column collagen tissue engineering scaffold, given the column has a length of 100 um, is circular in cross section, with a diameter of 2 um, and has a young´s modulus of 5 Mpas. You..
|
|
Benefits of a wedge connection on pipeline
: What are the main benefits of a Wedge Connection on pipelines ?
|
|
Following concepts related to exposure thresholds
: Briefly explain the following concepts related to exposure thresholds: time-weighted average, short-term exposure limit, exposure ceiling, and biological exposure indices.
|
|
Calaculate cost of goods is given as equivalent fob value
: Calaculate Cost of goods is given as the equivalent FOB value for customs purposes and Freight costs are for transport form the country of origin to Melbourne Victoria Australia.
|
|
Determine if the table satisfies 2nf
: Determine if the table satisfies 2NF. If the table is already in 2NF, say so. If a table violates 2NF, say so and produce the 2NF tables. It is sufficient to just list the results of 2NF normalization
|
|
Irontown incorporated-plan to reduce turnover
: In this case study, you will revisit Irontown Incorporated and prepare a plan to reduce turnover to meet the quality and cost objectives set by company leadership.
|
|
Create a bourne shell script
: you need to package your commands in a script so that the patching team can run them on the production environment - Create the directory structure and create the files as defined in the previous Individual Project.
|
|
Question regarding the desirable leadership role
: Setting: It is 5-10 years in the future and you have just been appointed to a highly desirable leadership role, one for which you have been preparing for many years. The organization has strong viability but is currently ineffective due to power s..
|
|
How the government has impacted public policy
: Analyze how the public policy that you chose has impacted the U.S. government - Discuss if these changes were beneficial for the American public or not. Support your answer.
|