CREATE TABLE youtubevideos(

url VARCHAR(150),

title VARCHAR(50),

description VARCHAR(200),

comid INTEGER NOT NULL,

postuserVARCHAR(50) NOT NULL,

postdate DATE,

PRIMARY KEY (email),

FOREIGN KEY (comid) REFERENCES Comedians(comid),

FOREIGN KEY (postuser) REFERENCES Users(email));

CREATE TABLE Users(

email VARCHAR(50),

password VARCHAR(50),

firstname VARCHAR(50),

lastname VARCHAR(50),

gender CHAR(1),

age INTEGER,

PRIMARY KEY (email));

CREATE TABLE Comedians(

comid INTEGER,

firstname VARCHAR(50),

lastname VARCHAR(50),

birthday DATE,

VARCHAR(50),

PRIMARY KEY(comid));

CREATE TABLE Reviews(

reviewid INTEGER NOT NULL AUTO_INCREMENT,

remark VARCHAR(100),

rating CHAR(1), //P.F.G.E

author VARCHAR(50) NOT NULL,

youtubeid VARCHAR(150) NOT NULL,

PRIMARY KEY (reviewid),

FOREIGN KEY (author) REFERENCES Users(email),

FOREIGN KEY (youtubeid) REFERENCES youtubevides(url),

CONSTRAINT rating,

CHECK rating ['P','F','G','E']

)

CREATE TABLE youtubetags(

url VARCHAR(150),

tag VARCHAR(50),

PRIMARY KEY (url, tag))

CREATE TABLE IsFavorite(

email VARCHAR(50),

comid INTEGER,

PRIMARY KEY (email, comid),

FORIGN KEY (email REFERENCES Users(email),

FOREIGN KEY (comid) REFERENCES Comedians(comid))

1. Return the names of the comedians that have youtubes but no reviews.
2. Return the URLs of the youtubes that have some reviews and each review is excellent.
3. Return the URLs of the youtubes that have some reviews and each review is given by some female user under 20 (not including 20).
4. Return the URLs of the youtubes that have no tags

use a page(roughly 300 words )to review Matthew Hayday, “Fireworks, Folk-Dancing and Fostering a National Identity: the Politics of Canada Day” Canadian Historical

   •   First Step:

Read Actively. Read the work through once. During this reading, pay attention to: (a) the author’s purpose; (b) the main ideas of the passage/article; (c) the author’s argument; (d) the support for the argument; (e) the author’s insights. This information will have to be concise and clear in your précis.

   •   Second Step:

Summarize . Read the work through again. Make a one-sentence summary of each paragraph or major division in the text. Now you have created a basic outline of the work.

   •   Third Step:

Writing. Depending on the required length of the assignment, write a short introductory paragraph or sentence. This should include, at a minimum, the author, the title and the thesis or main idea. Use the sentences you wrote in the second step as details to develop your short précis paragraph or as topic sentences for the body paragraphs in a longer précis assignment. Keep the body paragraphs as concise as possible, but make sure to include the necessary information that you noted when reading the work through the first time (purpose, research, methods, insights, support). To conclude the précis, summarize the thesis in a new paragraph and list any conclusions made by the author.

   •   Fourth Step:

Editing and Proofreading. Check your précis to make sure it meets all requirements. Check the initial work to make sure you have made a complete summary and have not added any personal opinion. Check for correct spelling and grammar, clarity, and coherence. Finally, read your précis aloud.

Calculate the total Ending Inventory value for 2016, 2017, 2018 and 2019 using dollar-value LIFO. (Show all calculations and the ending inventory amount for each of the years)

Year    Current year inventory            Index  

2016                $50,000                       1.00

2017                $72,000                       1.20

2018                $117,000                     1.30

2019                $119,000                     1.40

Question 4

Comparative financial statement data of Lannister Inc. are as follows:

Other information:

Market price of Lannister common stock: $102.17 at December 31, 2016; and $77.01 at December 31, 2015.

Common shares outstanding: 18,000 during 2016 and 17,500 during 2015.

All sales on credit.

Compute the following ratios for 2016 and 2015

Current ratio

Quick ratio (acid test)

Receivables turnover and days’ sales outstanding (rounded to the nearest whole day)

Inventory turnover and days inventory outstanding (rounded to the nearest whole day)

Accounts payable turnover and days’ payable outstanding (rounded to the nearest whole day).

Cash conversion cycle (in days)

Times-interest-earned ratio

Return on assets (use DuPont analysis)

Return on common shareholders’ equity (use DuPont analysis)

Earnings per share of common stock

Price/earnings ratio.

Decide whether (a) Lannister’s financial position improved or deteriorated during 2016 and (b) the investment attractiveness of Lannister’s common stock appears to have increased or decreased.

Comparative financial statement data of Lannister Inc. are as follows:

Other information:

• Market price of Lannister common stock: $102.17 at December 31, 2016; and $77.01 at December 31, 2015.
• Common shares outstanding: 18,000 during 2016 and 17,500 during 2015.
• All sales on credit.

1. Compute the following ratios for 2016 and 2015
   • Current ratio
   • Quick ratio (acid test)
   • Receivables turnover and days’ sales outstanding (rounded to the nearest whole day)
   • Inventory turnover and days inventory outstanding (rounded to the nearest whole day)
   • Accounts payable turnover and days’ payable outstanding (rounded to the nearest whole day).
   • Cash conversion cycle (in days)
   • Times-interest-earned ratio
   • Return on assets
   • Return on common shareholders’ equity
   • Earnings per share of common stock
   • Price/earnings ratio.
2. Decide whether (a) Lannister’s financial position improved or deteriorated during 2016 and (b) the investment attractiveness of Lannister’s common stock appears to have increased or decreased.

: Pam Tarver just opened an information technology consulting company and has thought for a long time about what to name it. She finally settled on the fictitious name Infoxx. Search the USPTO database to determine if the name Infoxx is available. Is it? If it is available, describe how Pam would go about obtaining a trademark on Infoxx or any other name.

Email username generator Write an application that asks the user to enter first name and last name. Generate the username from the first five letters of the last name, followed by the first two letters of the first name. Use the .toLowerCase() method to insure all strings are lower case. String aString = “Abcd” aString.toLowerCase(); aString = abcd Use aString.substring(start position, end position + 1) aString.substring(0, 3) yields the first 3 letters of a string If the last name is no more than five letters, use the entire name. If it is more than five letters, use the first 5 letters Print the email username you generated with @myCollege.edu appended

1. The following XML document describes some employees of a company.

<?xml version="1.0" encoding="UTF-8"?>

<company>

<person age="25" id="p29432" manager="p48293">

<ssn>123456789</ssn>

<name> John Davis</name>

<office>B432</office>

<phone>1234</phone>

</person>

<person age="27" id="p29333" manager="p48222">

<ssn>987654321</ssn>

<name>Jim Handler</name>

<office>B123</office>

</person>

<person age=55 id="p29432" manager="p48221">

<ssn>123456789</ssn>

<name> Christo Dichev</name>

<office>A4210</office>

<phone>2477</phone>

</person>

<person age="57" id="p29333" manager="p4832">

<ssn>987654321</ssn>

<name>Elva Jones</name>

<office>A4211</office>

</person>

</company>

1. Check if the XML document is well-formed. If it is not, change it so that it becomes

wellformed, making as little changes as possible.

2. Write a DTD for this XML document such that the corrected version of the example is

a valid XML document.

Write html code:

1. Define constructor functions Faculty and Course. An instance of Course has instance of Faculty as the value if its instructor instance variable.

Download testProb1.js and testProb1.html

Write two files (faculty.js and course.js)

Constructor function Faculty. Arguments name and dept; Instance variables, name (a string, with default ("name unknown")

Write get_ and set_ methods for both instance variables; toString() return strings of form "<name> of <dept>"

Constructor function Course Arguments name, times, instructorName, and instructorDept, all with string values

Instance variables name (a string, with default “unknown course name”)

                                 times (a string, with default “unknown times”)

instructor (instance of Faculty, with no default), constructed using new and the Faculty constructor

Define get_ and set_ methods for all instance variables

setinstructor() takes an instance of Faculty as its parameter

getinstructor() returns an instance of Faculty

toString() returns the string value of the name instance variable