Logout
CSC 105: 201801 A01 & A02: CSC 105: 201801 A01 & A02:
Tests & Quizzes
Quiz 3 CSC105, 2018
Part 1 of 2 – Access Databases
Questions about ER diagrams and Access tables
Question 1 of 4
The following Entity Relationship Diagram shows Directors, Movies, Roles, Actors,
Achievements for both actors and movies.
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.
A. 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”
B. 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”
My Workspace Academic Advising Competitions
CSc Assistance Centre More Sites
Home
Syllabus
Schedule
Announcements
Resources
Assignments
Tests & Quizzes
Gradebook
Drop Box
Chat Room
Course Outline
Site Info
Roster
Help
CSC 105: 201801 A01 & A02
12
https://connex.csc.uvic.ca/portal/logout
https://connex.csc.uvic.ca/portal/tool-reset/33f11a03-b593-45e4-aa9b-07d415c19033/?panel=Main
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#Main33f11a03xb593x45e4xaa9bx07d415c19033_directurl
https://connex.csc.uvic.ca/portal/help/main?help=sakai.samigo
https://connex.csc.uvic.ca/portal/site/~jqiu
https://connex.csc.uvic.ca/portal/site/advising
https://connex.csc.uvic.ca/portal/site/7879de3a-7764-4cab-addf-5dea29f8494c
https://connex.csc.uvic.ca/portal/site/cscassist
javascript:;
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/ff40f2a5-0f40-45bc-a1f9-4cbca29457c4
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/02a76816-33a8-44e0-8118-447e11d16b91
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/8e661a8d-3eb5-4980-a8f4-0746b3ae0db5
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/9ae1d128-7783-4f35-a498-506789749235
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/4cb4592d-abfc-4439-9624-8cc3ac4baea4
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/ea3c4764-34c6-46da-a1f9-bc8a29e41ab4
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/f7d5a557-2cff-4109-a10b-02d5d4fb8821
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/64a0447e-0d5e-4378-b6d6-abd8c2f561ef
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/5c8f6cc3-ad31-44ee-a3aa-bfff397a0807
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/89a1636d-de13-4ade-9d7c-65b3f4b9ce0f?sakai.popup=yes
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/098cf55a-7aa6-4412-b78e-6eccd437a898
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/c353e61c-68b2-438e-99d3-4e42e09b4bad
https://connex.csc.uvic.ca/portal/help/main
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
http://www.philosophy-index.com/traditions/western/
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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.
B. One to many going from Eras to Philosophers.
One to many going from Philosophers to Works.
C. One to many going from Philosophers to Eras.
One to many going from Works to Philosophers.
D. 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 Name,
12
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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
________________________
B. 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
________________________
C. 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
________________________
D. 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 “What is”
get a good overview of each of them )
12
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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.
A 1.
F 2.
C 3.
B 4.
D 5.
E 6.
Question 2 of 6
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
section of the HTML docyou 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.
< link rel="stylesheet" type="text/css" href=" First_try.css />
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) :
……
Hello World!! Welcome to HTML 5
…….
What would the web page look like in the browser? Choose the best answer.
12
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
p g
(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
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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
Question 5 of 6
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 Adventures in
12
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
http://www.html-5-tutorial.com/image-element.htm
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
y g y
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.)
B.
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):
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
http://www.w3schools.com/tags/att_a_target.asp
https://connex.csc.uvic.ca/portal/tool/33f11a03-b593-45e4-aa9b-07d415c19033/jsf/delivery/beginTakingAssessment#
http://web.uvic.ca/~msanseve/Quiz3/
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
}
C. body {
width: 99%;
margin: 2px auto;
font-family: Arial, sans-serif;
text-align: center;
}
D. header {
width: 50%;
margin: 4px auto;
border: 2px solid #00FF00;
}
E. header {
width: 90%;
margin: 4px auto;
border: 2px solid #0000FF;
}
F.
article {
width: 90%;
margin: 10px auto;
background-color: #FFFF00;
text-align: left;
}
Save Exit
12
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#
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
12
https://connex.csc.uvic.ca/portal/site/!gateway
https://connex.csc.uvic.ca/portal/pda
https://connex.csc.uvic.ca/portal/site/itsupport
http://www.csc.uvic.ca/
http://www.engr.uvic.ca/
http://www.uvic.ca/
https://connex.csc.uvic.ca/portal/site/831bb4eb-1992-4dbf-9401-6a7d9c64dd06/page/a7cb4163-6598-4a61-8c28-9fc4adc33097#