I need some help with My MySQL project. i need to create 3 specific tables

The first table named Faculty to store EMPLID, first name, last name, email, and year of birth and date of hire. I should set appropriate data types, sizes and constraints for the table.

the second table named Courses will store CourseID, the discipline name, course name, number of credits, date first offered and course title. i should select the appropriate data types, sizes and constraints for the table.

the third table named FacultyCourses will store the Faculty and the Courses they have taught. I should design this table based on the Faculty and Courses tables that were previously made. I should use Primary and Foreign Key relationships properly.

i have tried to make the third table but always get an error saying the ERROR 1215 (HY000): Cannot add foreign key constraint. I would appreciate any help

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to create a well-crafted topic paragraph about how either achebe or silko uses setting characters or plot to communicate the theme of continuity and change in story, but i don’t know how they do.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to create income statement, stockholders equity, balance sheet and cash flow statement projecting out 5 years based on Amazon 2018 10-k and an issuance of $5 billion in stock. I also need to analyze the impact of each. I am attaching the excel version of the 2018 financial statements.

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to design a cascaded amplifier using op-amps and comprising two stages. The first stage is to be a non-inverting amplifier of gain ” 3 ” and the second stage an inverting amplifier of gain of ” -2 “. The resistance R1 of both the first and second stage is to be 2 kΩ. Include a 1 kΩ load resistor at the output of the amplifier. The power supply for the amplifier circuit is ±15 V.

 A1. Calculate the magnitudes of the feedback resistors for each stage.

 A2. Determine the magnitude of the input signal that can be applied to the amplifier and result in linear amplification (i.e. the amplifier does not saturate). This will guide you in the intra laboratory exercise.

 A3. Draw the resulting amplifier circuit.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to develop a minimum analysis of inflation:I need to choose a product or service that I currently consume/use, (such as apparel or educational services), that is included in the CPI’s “market basket. I also need to find the annual CPI index numbers for my chosen good or service for the years 1995, 2005, 2010, and 2015. I then need to enter those index numbers in an Excel® file and calculate the percent change (inflation rates) in those index numbers from 1995 to 2005, from 1995 to 2010, and from 1995 to 2015. I need to also analyze the trends in overall inflation over the last five years and whether the income has kept pace with inflation. I also need to know how inflation over the last five years affected me and/or my family?]I also need to discuss how as a business manager, such as a human resources manager, may use CPI statistics.Where do I start?Stephanie

The CPI rates of coffee and the percentage change between the period is as followsYear19952005 CPI Rate163.133 Percentage change 161.225 -1.17% 2010 186.418 14.27% 2015 205.540 26% Source:…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"