database html代写: CSC 105

程序代写 CS代考 / database

he following Entity Relationship Diagram shows Directors, Movies, Roles, Actors, Achievements for both actors and movies.

Announcements

Resources

Assignments

Tests & Quizzes

Gradebook

Drop Box

Chat Room

Course Outline

Site Info

Roster

Help

You would like a list of all the actors (first name and last name) that have won a “Be Oscar” or a “Best Actress Oscar”. Using a shorthand SQL (where we omit the JOIN statements), select the SQL that correctly represents this query.

  1. SELECT Actors.F_Name, Actors.L_Name FROM Actors, Actor_Achievement, Awards

    WHERE Awards.Award_Name = “Best Actor Oscar” OR Awards.Award_Name = “Best Actress Oscar”

  2. SELECT Actors.F_Name, Actors.L_Name FROM Actors, Actor_Achievement, Awards

    WHERE Actor_Achievement.Award_ID= “Best Actor Oscar” OR Actor_Achievement.Award_ID= “Best Actress Oscar”

12

C. SELECT Actors.F_Name, Actors.L_Name FROM Actors, Awards

WHERE Awards.Award_Name = “Best Actor Oscar” OR Awards.Award_Name = “Best Actress Oscar”

Reset Selection

Question 2 of 4

You have created a database for a philosophy professor. The professor wants to ke different philosophers from the Western School of Philosophy (check out this web p overview of this school of thought and its accompanying eras : Western School of P

The database has three tables: Philosophers;
Works;
Eras

Each table has an ID that serves as a primary key.

Table Philosophers describes each philosopher and includes the following fields: Philosopher_ID
Name;
date of birth:

country of origin;
brief biographical overview

Table Works describes the works produced by each philosopher and includes the fields:
Works_ID;
Work Title,

medium (e.g. poem, prose, mathematical formula, map, painting, etc.), date the work was produced,
short description of the work.

Table Eras describes the eras that each philosopher practiced in, and includes the fields:
Era_ID;
Era name;

brief description of the era;
dates for the beginning of the era; dates for the end of the era.

The database enables the following rules

1). Each era will contain one or more philosophers.

2). Each philosopher will have completed one or more works.

The tables need some additional fields to allow for the one to many relationship bet What is required?

A. Table Philosophers needs to add Era_ID from Table Eras as a Foreign Key. Table Works needs to add Philosopher_ID from Table Philosophers as a Foreign Key.

B. Table Eras needs to add Philosopher_ID from Table Philosophers as a Foreign Key. Table Works needs to add Philosopher_ID from Table Philosophers as a Foreign Key.

C. Table Philosophers needs to add Works_ID from Table Works as a Foreign Key. Table Eras needs to add Philosopher_ID from Table Philosophers as a Foreign Key.

D. Table Philosophers needs to add Works_ID from Table Works as a Foreign Key. Table Works needs to add Era_ID from Table Eras as a Foreign Key.

12

Reset Selection

Question 3 of 4

Still referring to the Philosophers Database in the question above. If we were to dra normalized (3rd normal form) ER Diagram based on the rules and Primary –> Forei described above, what would the relationships be between the tables?

A. One to many going from Eras to Philosophers. One to one between Philosophers and Works.

  1. One to many going from Eras to Philosophers. One to many going from Philosophers to Works.
  2. One to many going from Philosophers to Eras. One to many going from Works to Philosophers.
  3. One to many going from Eras to Works.
    One to many going from Philosophers to Works.

Reset Selection

Question 4 of 4

Consider the following ER Diagram for the Movies database we have been working :

You are preparing some SQL queries against this database. Specifically, you want a movie titles,the first and last name of the movie director, and a list of characters in t where the movie has been ranked at 9 or better or the director ranked as 7 or bette Actor playing the character has been rated as better than 8.

You are going to draft your SQL by hand to put into Access later.
A. SELECT Movies.Title, Directors.D F Name, Directors.D L Na

12

e,

m

A. SELECT Movies.Title, Directors.D_F_Name, Directors.D_L_Name,

Roles.Character, Actors.F_Name, Actors.L_Name FROM Movies, Directors, Actors, Roles

WHERE (Movies.M_Rank >=9 OR Directors.D_Rank >=7) AND Actors.A_Rank >= 8

                 ________________________
  1. SELECT Movies.Title, Directors.D_F_Name, Directors.D_L_Name, Roles.Character

    FROM Movies, Directors, Roles

    WHERE (Movies.M_Rank >=9 OR Directors.D_Rank >=7) AND Actors.A_Rank > 8

                     ________________________
  2. SELECT Movies.Title, Directors.D_F_Name, Directors.D_L_Name, Roles.Character

    FROM Movies, Directors, Actors, Roles

    WHERE (Movies.M_Rank >=9 OR Directors.D_Rank >=7) AND Actors.A_Rank >= 8

                     ________________________
  3. SELECT Movies.Title, Directors.D_F_Name, Directors.D_L_Name, Roles.Character

    FROM Movies, Directors, Actors, Roles

    WHERE (Movies.M_Rank >=9 OR Directors.D_Rank >=7) AND Actors.A_Rank > 8

                     ________________________

Reset Selection

Part 2 of 2 – HTML, HTML5, and CSS: Beginning concepts

Questions about HTML, HTML5, and CSS — taken from the first few lectures and from the W3C website.

Question 1 of 6

Match the following HTML/HTML5 tags with their correct meaning. (Hint – not sure these tags mean? Try popping them into a Google search with the words “Wh1at2is”

get a good overview of each of them )

get a good overview of each of them.)

A. Text between these tags describes a web page.

B. Tags that typically contain a section heading (e.g. an H1 – H6 tag), but can conta content too.

C. Declares that the web page should be interpreted as HTML 5.

D. Tags, typically towards the top of the document, that instruct the browser where style sheets, provide meta information, and more.

E. Information between these tags define the title of the document. F. The text between these tags is visible page content.

Question 2 of 6

1. <HTML> </HTML>
2. <BODY> </BODY>
3. <!DOCTYPE html>
4. <HEADER> </HEADER> 5. <HEAD> </HEAD>

6. <TITLE> </TITLE>

Consider the following situation: You have created a cascading file sheet (CSS) call First_try.css

You know you need to reference it in the <Head> </Head> section of the HTML doc you want to apply the styles to. Imagine this line of HTML code is placed in the cor Moreover, First_try.css is in the same folder as the HTML file.

Fill in the blanks to correctly complete the reference.

< rel=”stylesheet” type=”text/css” href=” />

Question 3 of 6

Image that the following cascading style sheet information is correctly entered in a

body{
width: 95%;

font-family: Arial, “MS Trebuchet”, sans-serif; text-align: center; background-color:#000000;

}
h1{color: #ff00ff} header{

width: 75%;
margin: 15px auto; border: 2px solid #0000ff;

}

Furthermore, imagine that the .css file is correctly referenced in an HTML file. The H contains the following content in the BODY (all of the other tags – e.g. HTML open are correctly placed) :

……
<body>
<header>
<h1> Hello World!! Welcome to HTML 5 </h1> </header>
</body>
…….

What would the web page look like in the browser? Choose the best a

12

swer.

n

ssc.yrt_tsriFknil

E D B C F A

pg

(Hint — create a .html file and a .css file and add copy the content above into the fil them, and see what happens.)

A.

B. C.

12

D.

Reset Selection

Question 4 of 6

You have to place an image in a web page you are developing. The web page is ca index.html and is in a folder called www

The image you need to place is called biking.jpg and is in a folder called Images lo the www folder. The image should be 200 pixels wide and 150 pixels high.

Fill in the blanks in the IMG tag below such that the image will display correctly whe is run in a browser.

(Hint: If you are not sure about the ins and outs of an IMG tag, check out:

http://www.html-5-tutorial.com/image-element.htm

<IMG SRC=”

Question 5 of 6

” =”200″

=”150″>

You need to create a hyper link in your HTML document using an anchor tag. The li to http://bcoutofdoors.com/

In the browser you want the user to click on a string of text that says A n

12

dvent

ures i

htdiw gpj.gnikib/segamI

thgieh

ygy

You want the clickable link to open up http://bcoutofdoors.com/, but you want the open in a new page on either a new browser tab or a new browser window.

Which of the anchor tags and attributes listed below does this correctly? (Hint – not sure about how to do this — check out

http://www.w3schools.com/tags/att_a_target.asp for an overview.)
A. <A HREF=”bcoutofdoors.com/” target=”_blank”> Adventures in BC. </A>

B. <HREF=”http://bcoutofdoors.com/” target=”_blank”> Adventures in BC. </HREF>

C. <A HREF=”http://bcoutofdoors.com/” target=”_new”> Adventures in BC. </A>

D. <A HREF=”http://bcoutofdoors.com/” target=”_blank” “Adventures in BC.” /A>

E. <A HREF=”http://bcoutofdoors.com/” target=”_parent”> Adventures in BC. </A>

F. <A HREF=”http://bcoutofdoors.com/” target=”_blank”> Adventures in BC. </A>

Reset Selection

Question 6 of 6

Consider the following web page (it will open in its own tab or window):

http://web.uvic.ca/~msanseve/Quiz3/

Based on what you see in the above web page select from the Styles below and ch CSS that will correctly style the following tags/elements. There will be several choic tag pair, select the correct one for each pair — you should finish with three boxes c for each pair):

<HEADER> </HEADER> <ARTICLE> </ARTICLE> <BODY> </BODY>

This is a challenging question — use what you can see on the link above. As well, o FOOTER, HEADER, BODY, ARTICLE, ASIDE, NAV, and IMG tags have been styled. tags are in their default configurations.

A.

article {
 width: 100%;
 margin: 10px auto;
 background-color: #FFFF00;
 text-align: center;

}

B. body { width: 99%;

           margin: 2px auto;
           font-family: Arial, sans-serif;
           text-align: left;

12

}

C.

 body {
  width: 99%;
  margin: 2px auto;
  font-family: Arial, sans-serif;
  text-align: center;

}

header {
 width: 50%;
 margin: 4px auto;
 border: 2px solid #00FF00;

}

header {
 width: 90%;
 margin: 4px auto;
 border: 2px solid #0000FF;

}

article {
 width: 90%;
 margin: 10px auto;
 background-color: #FFFF00;
 text-align: left;

}

}

D.

E.

F.

12

tixE evaS

Gateway Mobile View ITSupport CSc Department Faculty of Engineering University of Victoria

Copyright 2003-2018, University of Victoria.

conneX – TRUNK – Sakai 10.5 (Kernel 10.5) – Server cnxapp5

Server Time: Sat, 10 Mar 2018 00:06:29 PST

Related Posts