In: Computer Science
Using MYSQL in terminal, create the tables for your above designed relational schema and populate your tables with appropriate data. All except time slot and the relationship it participates in. Use the names for the tables and attributes from the ER schema. Use ON DELETE CASCADE for foreign keys.
Each basic table (corresponding to an entity in the ER schema developed for Part 1) should have 5-10 rows. Campus can have just 2. Building should have at least 6. At least 1 building name (Laurel) should be in both campuses.
The remaining tables should have at least 10 rows. Make sure that your tables are in compliance with the participation constraints.
Show the following:
·create table commands that you used
·any commands that you used to insert or load into the tables (in the order in which they were performed- order matters!)
·content of you table as a result as a select * from (each table)
-----------------------
Here is the schema:
building(pk(building_name), num_floors, num_classrooms)
campus(pk(campus_name), state_name, school_name)
classroom(pk(room_number), capacity)
course(pk(course_id), title, credits)
instructor(pk(iid), salary, inst_name)
department(pk(dept_name), budget)
student(pk(sid), stud_name, tot_cred)
time_slot(pk(time_slot_id), {day, start_time, end_time})
section(pk(section_id), pk(semester), pk(year))
has(pk(dept_name, building_name), fk(dept_name) ref
department(dept_name), fk(building_name) ref
building(building_name))
course_dept(pk(dept_name, course_id), fk(dept_name) ref
department(dept_name), fk(course_id) ref course(course_id))
inst_dept(pk(dept_name, iid), fk(dept_name) ref
department(dept_name), fk(iid) ref instructor(iid))
mentors(pk(iid, sid), fk(iid) ref instructor(iid), fk(sid) ref
student(sid))
stud_dept(pk(dept_name, sid), fk(dept_name) ref
department(dept_name), fk(sid) ref student(sid))
takes(pk(sid, section_id), grade, fk(sid) ref student(sid),
fk(section_id) ref section(section_id))
sec_time_slot(pk(time_slot_id), pk(section_id, semester, year),
fk(time_slot_id) ref time_slot(time_slot_id), fk(section_id,
semester, year) ref section(section_id, semester, year))
sec_class(pk(section_id, room_number), fk(section_id) ref section,
fk(room_number) ref classroom(room_number))
teaches(pk(iid), pk(section_id, semester, year), fk(iid) ref
instructor(iid), fk(section_id, semester, year) ref
(section(section_id, semester, year)))
prereq(pk(course_id), fk(course_id) ref course)
In: Computer Science
Reflect on what kind of leader would be best for your chosen business: Autocratic, democratic or free-rein? Explain why, and think about how the leadership style you picked would fit with the kinds of employees you would have, and the industry in which they work. Finally, explain whether you are that kind of leader, and why you think so, or don't think so.
In: Finance
Use the AD/AS model to illustrate what happens to United States equilibrium GDP and the price level under the following scenarios. Also state what happens to national income and unemployment.
1. Canada, the number one destination of U.S. exports, goes into recession.
2. Energy prices rise throughout the economy.
3. Wages fall throughout the economy.
4. Congress passes a law lowering the income tax.
5. Businesses become more optimistic and raise their forecast ROI.
Include a caption! Beside or below each graph, explain why you shifted the curve.
In: Economics
In: Statistics and Probability
Anova
5) The data below gives the lengths in millimeters of three varieties of the tropical flower Heliconia, which are fertilized by different species of a hummingbird on the island of Dominica. Perform an Anova test to compare the means lengths of the flowers for the three species.
|
H. bihai |
H. caribaea red |
H. caribaea yellow |
|
46.8 |
37.8 |
34.5 |
|
46.4 |
37.4 |
35.7 |
|
46.9 |
38 |
35 |
|
47.4 |
38.9 |
36.5 |
|
48.4 |
38 |
36.7 |
|
48 |
41.5 |
36 |
|
50.2 |
41.9 |
37 |
|
a. State the null and alternative hypothesis |
|
|
b. Give the p-value |
|
|
c. Give a conclusion for the hypothesis test |
In: Statistics and Probability
The government of a state has been experiencing an increase in number of obesity cases. Research suggests an increase in consumption of a particular fast food item is responsible for high number of obesity cases. As a result, the government of that State is considering an imposition of $1 tax. Monthly demand and supply for this good are QD=21-1P and QS= -1+1P respectively.
a) Draw the demand and Supply curve for fast food before the tax is imposed. Calculate the
equilibrium price and quantity, consumer and producer surplus, and label them on the graph.
b) Calculate the price elasticity of demand and supply for fast food. If the State government
imposes a tax, who will bear the most of the burden of the tax?
c) Suppose that the State government finally imposes a $1 tax on fast food. What will the new
equilibrium price and quantity? Include the tax on your graph. Calculate the consumer and
producer surplus and label them on the graph.
d) Is there any deadweight loss resulting from the tax on that good? If so, calculate it and if not,
explain? Would you personally advice the State government to impose the tax or not?
In: Economics
The government of a State has been experiencing an increase in number of obesity cases. Research suggests an increase in consumption of a particular fast food item is responsible for high number of obesity cases. As a result, the government of that State is considering an imposition of $1 tax. Monthly demand and supply for this good are QD=21-1P and QS= -1+1P respectively. (30 Pts) a) Draw the demand and Supply curve for fast food before the tax is imposed. Calculate the equilibrium price and quantity, consumer and producer surplus, and label them on the graph. b) Calculate the price elasticity of demand and supply for fast food. If the State government imposes a tax, who will bear the most of the burden of the tax? c) Suppose that the State government finally imposes a $1 tax on fast food. What will the new equilibrium price and quantity? Include the tax on your graph. Calculate the consumer and producer surplus and label them on the graph. d) Is there any deadweight loss resulting from the tax on that good? If so, calculate it and if not, explain? Would you personally advice the State government to impose the tax or not?
In: Economics
Review the four financial statements discussed in Chapter 1. Then answer the following questions in your initial response:
Word Count: 175- to 265-words. Use your own thoughts, experience and viewpoint of the readings. Do not copy from the internet.
APA Formatting: Use citations where appropriate and list references. All citations and references, if used, must be in APA format. Only 15% of the content can be source material. If you write in your own words, only the reference is required.
In: Accounting
In: Accounting