Search Header Logo

ICT285 PASS Week 13

Authored by Jason Holloway

Computers

University

Used 2+ times

ICT285 PASS Week 13
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

REORDER QUESTION

2 mins • 1 pt

CUSTOMER (CustomerNumber, CustomerName, DateOfBirth)

EMPLOYEE (EmployeeNumber, EmployeeName, DateOfBirth)

SALE (SaleID, CustomerNumber, EmployeeNumber, Cost)

What is the CustomerName for SaleID='1111'? Reorder the following steps.

PROJECT CustomerName (JOINED)

RESTRICT SaleID='1111' (SALE)

CUSTOMER* CUSTOMER.CUSTOMERNUMBER = SALE.CUSTOMERNUMBER RES_SALE

2.

REORDER QUESTION

2 mins • 1 pt

SALESPERSON(SPN, Name, StartYear, DeptNo)

TRIP(TripID, ToCity, DepartDate, ReturnDate, SPN)

EXPENSE(TripID, Account#, Amount)

Give the TripID for all trips by salesperson 'Steve'. Reorder the following steps.

PROJECT TripID (TRIP)

RESTRICT Name='Steve' (SALESPERSON)

RES_SALE* RES_SALE.SPN = TRIP.SPN TRIP

3.

REORDER QUESTION

2 mins • 1 pt

SALESPERSON(SPN, Name, StartYear, DeptNo)

TRIP(TripID, ToCity, DepartDate, ReturnDate, SPN)

EXPENSE(TripID, Account#, Amount)

Give the names of sales people that have NOT gone to Sydney. Reorder the following steps.

PROJECT Name (JOINED) -> ALL_SYD_NAMES

PROJECT Name (SALESPERSON) -> ALL_NAMES

SALESPERSON* SALESPERSON.SPN = TRIPS_SYDNEY.SPN TRIPS_SYDNEY -> JOINED

ALL_NAMES MINUS ALL_SYD_NAMES

RESTRICT ToCity='Sydney' (TRIP) -> TRIPS_SYDNEY

4.

REORDER QUESTION

2 mins • 1 pt

PROPERTY (PropertyNo, Address, NumberOfRooms, OwnerNo)

OWNER (OwnerNo, FamilyName, GivenNames, Address)

List the family names for owners that own properties with more than 3 rooms. Reorder the following steps.

RESTRICT NumberOfRooms > 3 (PROPERTY)

PROJECT FamilyName (RES_JOINED)

OWNER* OWNER.OwnerNo=RES_3.OwnerNo RES_3

5.

REORDER QUESTION

2 mins • 1 pt

PROPERTY (PropertyNo, Address, NumberOfRooms, OwnerNo)

OWNER (OwnerNo, FamilyName, GivenNames, Address)

List the family names for owners that do not own properties. Reorder the following steps.

PROJECT OWNER TABLE FIRST.

PROJECT OwnerNo (OWNER) -> ALL_OWNERS

PROJECT FamilyName (ALL_NON_OWNERS)

PROJECT OwnerNo (PROPERTY) -> ALL_PROP_OWNERS

ALL_OWNERS MINUS ALL_PROP_OWNERS -> ALL_NON_OWNERS

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

What normal form is this table in?

Invalid

1NF

2NF

3NF

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

What normal form is this table in?

Invalid

1NF

2NF

3NF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?