magnusandy 355DatabaseSQL issues

magnusandy / 355DatabaseSQL

0 stars 1 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Trigger: on insert into t_item_locations

#39 RyanLaForge closed 9 years ago
0
Trigger: delete form exhibitions

#38 RyanLaForge opened 9 years ago
0
Trigger: update exhibitions table

#37 RyanLaForge opened 9 years ago
0
Not possible: Trigger: delete from t_exhibition_items

#36 RyanLaForge closed 9 years ago
1
Trigger: update t_exhibition_items

#35 RyanLaForge opened 9 years ago
0
Trigger: delete from t_exhibition_locations

#34 RyanLaForge closed 9 years ago
1
Trigger: update t_exhibition_locations

#33 RyanLaForge opened 9 years ago
0
Trigger: insert on t_exhibition_locations

#32 RyanLaForge opened 9 years ago
0
Trigger: On update to t_item_locations, ensure that the last item is not the one updated.

#31 RyanLaForge opened 9 years ago
0
Trigger: on update to t_item_locations, possibly update exhibition items.

#30 RyanLaForge opened 9 years ago
0
Trigger: On insert into t_item_locations, possibly update exhibition items

#29 RyanLaForge opened 9 years ago
0
DBVISUALIZER BUG VERY IMPORTANT

#28 RyanLaForge opened 9 years ago
1
Transaction Idea: Loan Item**

#27 RyanLaForge closed 9 years ago
1
Transaction Idea COMPLTED NEEDS SQL SCRIPT:Borrow item

#26 RyanLaForge closed 9 years ago
0
Transaction Idea: sell item

#25 RyanLaForge closed 9 years ago
2
Transaction Idea: buy item

#24 RyanLaForge opened 9 years ago
4
Query Idea: All available items

#23 RyanLaForge closed 9 years ago
1
Query Idea: The earliest ending exhibitions, or exhibitions that have ended

#22 RyanLaForge closed 9 years ago
0
Query Assignment3: Produce a query that lists all the works found in an exhibition between two dates

#21 RyanLaForge closed 9 years ago
1
COMPLETE Query Idea: Produce a query that lists what locations an exhibition is currently in.

#20 RyanLaForge closed 9 years ago
1
Query Idea:Produce a transaction history for a particular client

#19 RyanLaForge closed 9 years ago
1
Query: The transaction history of an item

#18 RyanLaForge closed 9 years ago
2
Query: Logistics manifest(long)

#17 RyanLaForge closed 9 years ago
0
Query: Logistics manifest(short version)

#16 RyanLaForge closed 9 years ago
1
Transaction Idea: Insert an item with a different default location

#15 RyanLaForge opened 9 years ago
0
Transaction: Insert a new item, which may also have a new client.

#14 RyanLaForge opened 9 years ago
0
Transaction: Insert an item into an exhibition between two dates.

#13 RyanLaForge opened 9 years ago
0
Query:What exhibitions has an item been in between two dates.

#12 RyanLaForge closed 9 years ago
2
Query Assignment3: Produce a query that lists all the works found in an exhibition between two dates

#11 RyanLaForge closed 9 years ago
2
Query: What items have been in an exhibition between two dates.

#10 RyanLaForge closed 9 years ago
1
Query Assignment 3: Produce a query that lists all the exhibitions that make use of a location between two dates

#9 RyanLaForge closed 9 years ago
2
Query: What items have been in a location between two dates.

#8 RyanLaForge closed 9 years ago
2
Transaction *COMPLETE*: Add item to exhibition

#7 RyanLaForge closed 9 years ago
1
Trigger: on insert into item locatons, update the previous end date for that item. ***

#6 RyanLaForge closed 9 years ago
2
Trigger: on insert into item transactions, update item client key.

#5 RyanLaForge closed 9 years ago
1
Trigger: on insert into item transactions, update item acquisition. ***

#4 RyanLaForge closed 9 years ago
1
Trigger: on insert into transactions, update item locations.

#3 RyanLaForge closed 9 years ago
0
*COMPLETE* Trigger: on insert to items, insert into itemlocations(storage)

#2 RyanLaForge closed 9 years ago
0
*COMPLETE* Trigger Idea: on insert into doors, insert the opposite door into doors.

#1 magnusandy closed 9 years ago
3