1. List department name, employee id, and employee name for all employees in department name order.
2. Repeat for department #10 only.
3. List the course ID, course name, section, instructor name, day, time, and room for all course sections.
4. List the course ID, course name, section, student ID, and student name for CRN 1003. Display the list in ascending order of student last and first names.

DROP TABLE registration;
DROP TABLE sections;
DROP TABLE courses;
DROP TABLE students;
DROP TABLE instructors;

CREATE TABLE courses (
   cid varchar2(9) NOT NULL,
   cname varchar2(50) NOT NULL,
   credits number(1) DEFAULT 3,
   prereq varchar2(9),
   CONSTRAINT pk_courses PRIMARY KEY (cid)
);

INSERT INTO courses VALUES ('IS 201','Java Programming',3,null);
INSERT INTO courses VALUES ('IS 202','C++ Programming',3,'IS 201');
INSERT INTO courses VALUES ('IS 301','Web Design',3,null);
INSERT INTO courses VALUES ('IS 331','Business Applications',3,null);
INSERT INTO courses VALUES ('IS 401','Database Design',3,'IS 331');
INSERT INTO courses VALUES ('IS 413','SQL Programming',3,'IS 401');

CREATE TABLE students (
   sid char(9) NOT NULL,
   lname varchar(30) NOT NULL ,
   fname varchar2(30) NOT NULL ,
   gender char(1) NOT NULL ,
   addr varchar2(50) NOT NULL ,
   city varchar2(20) NOT NULL ,
   state char(2) NOT NULL ,
   zip varchar2(10) NOT NULL ,
   phone varchar2(14) NULL ,
   birthdate date NULL ,
   tuitionRate number(7, 2) NOT NULL ,
   creditsEarned number(3) NOT NULL ,
   CONSTRAINT pk_students PRIMARY KEY (sid)
);

INSERT INTO students VALUES ('100000001','Lee','George','M','15 Merchant Street','Honolulu','HI','96818','808-524-3333','01-MAY-1965',5000.00,47);
INSERT INTO students VALUES ('100000002','Yamamoto','Bill','M','3432 Birch Street','Honolulu','HI','96814','808-522-2212','03-JUN-1958',5000.00,12);
INSERT INTO students VALUES ('100000003','Carver','Hillary','F','22 Aardvark Avenue','Washington','DC','10101','800-212-3246','23-AUG-1991',5000.00,69);
INSERT INTO students VALUES ('100000004','King','Linda','F','341 Kaapahu Road','Paauilo','HI','96776',NULL,'01-SEP-1998',4399.00,6);
INSERT INTO students VALUES ('100000005','Rollings','Willie','M','1221 Ala Moana Blvd','Honolulu','HI','96814',NULL,NULL,4888.00,0);
INSERT INTO students VALUES ('100000006','Alexander','Wanda','F','93-123 Old Mill Road','Honokaa','HI','96727','808-776-2313','02-OCT-1997',5000.00,99);
INSERT INTO students VALUES ('100000007','Carver','Bill','M','33 Richards Street','Honolulu','HI','96813',NULL,'22-OCT-1990',5000.00,0);
INSERT INTO students VALUES ('100000008','DeLuz','Bob','M','102 Orleans Ave','San Francisco','CA','97745','808-555-3324','01-MAR-1998',5000.00,14);
INSERT INTO students VALUES ('100000009','Lee','Lisa','F','45 Fong Avenue','San Francisco','CA','97767','808-333-3432','21-APR-1997',5000.00,26);
INSERT INTO students VALUES ('100000010','Garcia','Sherrie','F','2 S. Beretania','Honolulu','HI','96817','808-663-4453','03-DEC-1997',5000.00,29);
INSERT INTO students VALUES ('100000011','Kamaka','Oscar','M','34 Kapolani Blvd','Honolulu','HI','96813','808-533-3332','12-FEB-1998',5000.00,0);

CREATE TABLE instructors (
   inId char(9) NOT NULL,
   iLname varchar2(30) NOT NULL,
   iFname varchar2(30) NOT NULL,
   rank varchar2(10) NOT NULL,
   office varchar2(10) NULL,
   phone varchar2(20) NULL,
   salary number(8,2) DEFAULT 0,
   CONSTRAINT pk_instructors PRIMARY KEY (inID)
);

INSERT INTO instructors VALUES ('200000001','Souza','Edward','Lecturer','LM101','808-533-4241',5000.00);
INSERT INTO instructors VALUES ('200000002','Tenzer','Laurie','Associate','LM102','808-533-4244',5000.00);
INSERT INTO instructors VALUES ('200000003','Otake','Bill','Assistant','MR101','808-533-4247',5800.00);

CREATE TABLE sections (
   crn char(4) NOT NULL,
   cid varchar2(9) NOT NULL,
   section char DEFAULT 'A',
   inId char(9) NOT NULL,
   days varchar2(10) DEFAULT 'TBA',
   time varchar2(16) DEFAULT 'TBA',
   room varchar2(10) NULL,
   CONSTRAINT pk_sections PRIMARY KEY (crn),
   CONSTRAINT fk_inid_sections FOREIGN KEY (inid) REFERENCES instructors(inid),
   CONSTRAINT fk_cid_sections FOREIGN KEY (cid) REFERENCES courses(cid)
);

INSERT INTO sections VALUES ('1000','IS 201','A','200000003','MWF','08:00 - 08:50','CL100');
INSERT INTO sections VALUES ('1001','IS 201','B','200000003','MWF','09:00 - 09:50','CL100');
INSERT INTO sections VALUES ('1002','IS 201','C','200000001','TTh','08:00 - 09:15','CL102');
INSERT INTO sections VALUES ('1003','IS 301','A','200000002','TTh','09:30 - 10:45','CL340');
INSERT INTO sections VALUES ('1004','IS 301','B','200000002','MWF','09:00 - 09:50','CL340');
INSERT INTO sections VALUES ('1005','IS 413','A','200000001','MWF','09:00 - 09:50','CL230');

CREATE TABLE registration (
   crn char(4) NOT NULL,
   sid char(9) NOT NULL,
   CONSTRAINT pk_registration PRIMARY KEY (crn,sid),
   CONSTRAINT fk_crn_registration FOREIGN KEY (crn) references sections(crn),
   CONSTRAINT fk_sid_registration FOREIGN KEY (sid) references students(sid)
);

INSERT INTO registration VALUES ('1000','100000001');
INSERT INTO registration VALUES ('1003','100000001');
INSERT INTO registration VALUES ('1005','100000001');
INSERT INTO registration VALUES ('1001','100000002');
INSERT INTO registration VALUES ('1004','100000002');
INSERT INTO registration VALUES ('1005','100000003');
INSERT INTO registration VALUES ('1002','100000004');
INSERT INTO registration VALUES ('1003','100000004');
INSERT INTO registration VALUES ('1005','100000004');
INSERT INTO registration VALUES ('1000','100000005');
INSERT INTO registration VALUES ('1003','100000005');
INSERT INTO registration VALUES ('1002','100000008');
INSERT INTO registration VALUES ('1004','100000008');
INSERT INTO registration VALUES ('1002','100000009');
INSERT INTO registration VALUES ('1005','100000009');
INSERT INTO registration VALUES ('1002','100000010');
INSERT INTO registration VALUES ('1005','100000010');
INSERT INTO registration VALUES ('1000','100000011');
INSERT INTO registration VALUES ('1003','100000011');
INSERT INTO registration VALUES ('1005','100000011');
commit;

1. Given a function φ(z) with z = x+iy let

   U(x, y) = ½ [φ(x+iy) + φ(x-iy)] and V(x, y) = i/2 [φ(x+iy) –φ(x-iy)]

A) For φ(z) = z² find U and V and their induced vector fields E =▼U and

F =▼V also show that ▼²U = ▼²V = 0

B) Repeat for f(z) = z³

C) For f(z) = ln z we get U(x, y) = ½ ln (x²+y²) and V(x, y) = arctan (y/x) Find ▼U (electrostatic field) and ▼V (magnetic field) . Also, show that ▼²U = ▼²V = 0 for x²+y² ǂ 0.

a 2d collision

Perform a linear fit, of the form x = A*t + B, to each graph and determine the initial velocity v1 and the final velocities v′1x, v′1y, v′2x, and v′2y. How do I find the v′1y

if: time (sec)= 0.400, 0.460, 0.500, 0.530, 0.560, 0.600, 0.630, 0.670, 0.700, 0.730, 0.700,0.800, 0.830, 0.867, 0.900

position (m) in y dxn= 85, 100, 120, 140, 160, 180, 190, 210, 230, 240, 260, 270, 290, 300, 320

position (m) in x dxn= 800, 850, 920, 980, 1000, 1080, 1140, 1190, 1230, 1280, 1300, 1400, 1440, 1490, 1500

a) Calculate the cell potential at 25°C for the cell

Fe(s) I (Fe²⁺ (0.100 M) II Pd²⁺ (1.0 × 10^-5 M) I Pd(s)

given that the standard reduction potential for Fe²⁺/Fe is -0.45 V and for Pd²⁺/Pd is +0.95 V. - Please show the steps

Larkspur Golf Inc. was formed on July 1, 2016, when Matt Magilke purchased the Old Master Golf Company. Old Master provides video golf instruction at kiosks in shopping malls. Magilke plans to integrate the instructional business into his golf equipment and accessory stores. Magilke paid $770,000 cash for Old Master. At the time, Old Master’s balance sheet reported assets of $670,000 and liabilities of $210,000 (thus owners’ equity was $460,000). The fair value of Old Master’s assets is estimated to be $800,000. Included in the assets is the Old Master trade name with a fair value of $12,000 and a copyright on some instructional books with a fair value of $43,200. The trade name has a remaining life of 5 years and can be renewed at nominal cost indefinitely. The copyright has a remaining life of 40 years. Prepare the intangible assets section of Larkspur Golf Inc. at December 31, 2016. LARKSPUR GOLF INC. Intangibles Section of Balance Sheet Goodwill $ Trade Names 12000 Copyrights $ How much amortization expense is included in Larkspur income for the year ended December 31, 2016? Amortization expense $ SHOW LIST OF ACCOUNTS Prepare the journal entry to record amortization expense for 2017. Prepare the intangible assets section of Larkspur Golf Inc. at December 31, 2017. (No impairments are required to be recorded in 2017.) (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Account Titles and Explanation Debit Credit LARKSPUR GOLF INC. Intangibles Section of Balance Sheet $ $ SHOW LIST OF ACCOUNTS At the end of 2018, Magilke is evaluating the results of the instructional business. Due to fierce competition from online and television (e.g., the Golf Channel), the Old Master reporting unit has been losing money. Its book value is now $410,000. The fair value of the Old Master reporting unit is $330,000. The implied value of goodwill is $100,000. Magilke has collected the following information related to the company’s intangible assets. Intangible Asset Expected Cash Flows (undiscounted) Fair Values Trade names $13,800 $4,600 Copyrights 46,000 41,000 Prepare the journal entries required, if any, to record impairments on Larkspur intangible assets. (Assume that any amortization for 2018 has been recorded.) (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Account Titles and Explanation Debit Credit

Larkspur Golf Inc. was formed on July 1, 2016, when Matt Magilke purchased the Old Master Golf Company. Old Master provides video golf instruction at kiosks in shopping malls. Magilke plans to integrate the instructional business into his golf equipment and accessory stores. Magilke paid $770,000 cash for Old Master. At the time, Old Master’s balance sheet reported assets of $670,000 and liabilities of $210,000 (thus owners’ equity was $460,000). The fair value of Old Master’s assets is estimated to be $800,000. Included in the assets is the Old Master trade name with a fair value of $12,000 and a copyright on some instructional books with a fair value of $43,200. The trade name has a remaining life of 5 years and can be renewed at nominal cost indefinitely. The copyright has a remaining life of 40 years. Prepare the intangible assets section of Larkspur Golf Inc. at December 31, 2016. LARKSPUR GOLF INC. Intangibles Section of Balance Sheet $ $ How much amortization expense is included in Larkspur income for the year ended December 31, 2016? Amortization expense $ SHOW LIST OF ACCOUNTS LINK TO TEXT LINK TO TEXT LINK TO TEXT Prepare the journal entry to record amortization expense for 2017. Prepare the intangible assets section of Larkspur Golf Inc. at December 31, 2017. (No impairments are required to be recorded in 2017.) (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Account Titles and Explanation Debit Credit LARKSPUR GOLF INC. Intangibles Section of Balance Sheet $ $ SHOW LIST OF ACCOUNTS LINK TO TEXT LINK TO TEXT LINK TO TEXT At the end of 2018, Magilke is evaluating the results of the instructional business. Due to fierce competition from online and television (e.g., the Golf Channel), the Old Master reporting unit has been losing money. Its book value is now $410,000. The fair value of the Old Master reporting unit is $330,000. The implied value of goodwill is $100,000. Magilke has collected the following information related to the company’s intangible assets. Intangible Asset Expected Cash Flows (undiscounted) Fair Values Trade names $13,800 $4,600 Copyrights 46,000 41,000 Prepare the journal entries required, if any, to record impairments on Larkspur intangible assets. (Assume that any amortization for 2018 has been recorded.) (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Account Titles and Explanation Debit Credit

SQL

This assignment aligns with the following objectives:

• Create a relational database containing at least three tables
• Populate the database using the INSERT command
• Create integrity constraints on the tables created

Deli has hired you as a consultant to design a database for the deli. They have provided you with the following information:

• Every employee has a social security number, name, salary, and date of hire.
• The deli is organized into several departments. Each department has a unique name.
• Each department has exactly one employee as its manager but an employee may manage more than one department. The database should record the date when the most recent manager of each dept. was appointed in that position.
• very employee must be assigned a department.
• Every employee has a supervisor who need not be the manager of any department.

The deli has these four departments:

1. hot foods
2. sandwich
3. snacks
4. beverage

You are provided the following additional information, which should be inserted into the database using SQL queries (not using any GUI interfaces, such as PhpMyAdmin):

• Jim Jones (ssn: 134-56-8877, salary: $28,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Rita Bita)
• Rita Bita (ssn: 138-56-8050, salary: $32,000, dept: beverages, date of hire: 2/15/2017, supervisor: Holly Dew. manages: beverages, starting 3/18/2018)
• Holly Dew (ssn: 334-55-8877, salary: $29,000, dept:sandwich, date of hire: 1/15/2016, supervisor: Pablo Escobar)
• Pablo Escobar (ssn: 666-56-6666, salary: $48,000, dept:snacks, date of hire: 1/26/2014, supervisor: Rita Bita, manages: snacks, starting 5/5/2015)
• Al Capone (ssn: 888-91-8870, salary: $40,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Pablo Escobar, manages: hot foods, starting 1/1/2016)
• Bonnie Clyde (ssn: 111-22-3333, salary: $42,000, dept: sandwiches, date of hire: 4/7/2015, supervisor: Al Capone, manages: sandwich, starting 1/1/2016)

Helpful Hints:

Please do not assume that the database should be structured in the way this data is provided. Your database should be structured such that constraints such as “Each dept. has exactly one employee as a manager” can be enforced.

There should not be a separate table for Deli – the entire database represents the deli. There should be a table for each major entity mentioned in the specifications. Relations between entities (such as, who works in which department) should be their own tables. Primary keys for each table should be chosen to enforce constraints.