Given the following relation schemes:

Teacher = [CourseN, Quarter,TeacherName]
Course = [CourseN,CourseName, Nunit)
Student = [studentName, CourseN, Quarter]
LocationNTime = [CourseN, Quarter , DayTime,  RoomN]

//Examples of DayTime: M2:00AM, W4:50PM, and T8:00PM. Note that DayTime is represented as a string.

Express the following queries by SQL statements and test them using any appropriate data. Take screenshots of the result, please let me know what program you use and please show all answers in complete form.

1. List the name of every teacher (distinct names) who teaches in RoomN 34 in Winter2011.

2. List CourseN, CourseName,  and TeacherName of every course meets on Monday PM.

3. List the name of every teacher who taught at least one course in RroomN 723.

4. List the CourseN, Quarter, RoomN and DayTime of every course taught by Karen Reed in the Spring 2005.

5. List the CourseN and TeacherName of every course taken by the student Ron Smith or by the student David Weidman.

6. List the CourseN and Quarter of every course taught by Karen Reed and met or meets in RoomN 713.

7. List the name of every teacher who has taught the same course at least two times.

8. List the name of every teacher( distinct names) who has taught at least two different courses in the same or different quarters.

9. List the CourseN, CourseName, and Quarter which meets or met at least two times a week.

10. List the CourseN and CourseName of every course with number of units > 4.

11. List every course number and students name who has taken the course at least twice.

12. Use * to list the CourseN, CourseName, Nunit, Quarter, TeacherName of every
course sorted by CourseN ascending, CourseName descending. 

13. List the CourseN and Quarter of every course taught by two different instructors in the same quarter ordered by the CourseN in descending order.

Design an object card
Design an object Deck
Design a driver program

Use these class diagrams to create your objects.

————————————-
                    Card
————————————-
-int _value
-String _suit
-String _Color
-String _Face
————————————-
+Card(int value, String suit)
+String toString()
+String getColor()
+String getFace()
+int getValue()
+String getSuit()
————————————

————————————
                    Deck
————————————
-List <Card> _cards
————————————
+Deck()
-void loadCards()
+Card drawCard()
+int getDeckSize()
+void shuffle()
————————————

Write a driver program that produces the output below.
Your program must match the provided class diagrams.
The program must draw a card randomly from a standard deck of 52 cards.
Your program must not print the same card twice until the deck runs out.
Your program must shuffle the deck when it runs out of cards.
Your program should produce different output every time it runs (Based on randomly selecting cards)
Each object and the driver program should be in separate files.

SAMPLE RUN #1: java Driver

Printing 79 random cards

Jack of Spades
5 of Diamonds
10 of Spades
3 of Clubs
Ace of Diamonds
King of Clubs
King of Hearts
7 of Clubs
2 of Diamonds
8 of Spades
9 of Clubs
2 of Spades
Ace of Spades
2 of Clubs
10 of Hearts
3 of Spades
2 of Hearts
4 of Spades
7 of Spades
Queen of Spades
10 of Diamonds
3 of Diamonds
Queen of Hearts
6 of Diamonds
9 of Hearts
King of Diamonds
4 of Diamonds
8 of Hearts
Jack of Hearts
Queen of Clubs
Ace of Hearts
7 of Diamonds
10 of Clubs
9 of Diamonds
Jack of Diamonds
Queen of Diamonds
4 of Clubs
6 of Hearts
8 of Diamonds
6 of Spades
7 of Hearts
3 of Hearts
8 of Clubs
5 of Spades
9 of Spades
5 of Hearts
King of Spades
4 of Hearts
6 of Clubs
Ace of Clubs
5 of Clubs
Deck is empty, shuffling!
Queen of Hearts
6 of Diamonds
4 of Spades
7 of Diamonds
Queen of Clubs
4 of Diamonds
8 of Hearts
King of Diamonds
5 of Spades
Jack of Clubs
7 of Hearts
7 of Clubs
2 of Diamonds
6 of Hearts
6 of Clubs
Jack of Diamonds
Queen of Diamonds
4 of Hearts
3 of Clubs
10 of Diamonds
Ace of Spades
Ace of Hearts
3 of Hearts
5 of Clubs
8 of Spades
3 of Diamonds
King of Clubs
King of Spades
Deck Remaining 24
Poker Hand !
10 of Spades
2 of Hearts
Ace of Diamonds
Jack of Spades
King of Hearts
Deck Remaining 19

For this assignment, you will be writing classes that model different kinds of 2
dimensional shapes, and each shape will be able to calculate its perimeter and area.
Well define a superclass call Shape, that consists of a set of points in 2 dimensional
space (Point2D), which represent the vertices and are ordered such that any given
Point2D and the next Point2D represent an edge (a side) of the shape, in a clockwise
manner. The last point and the first point are also assumed to define an edge. The
Point2D objects should be fed into the constructor for each shape IN THAT ORDER.

1)Write a method delete() that takes an int argument k and deletes the kth element in a
linked list, if it exists.
(i want to be able to choose what my input k will be, i do want hard coded and do not use  )

2)Write a method max() that takes a reference to the first node in a linked list as argument and returns the value of the maximum key in the list. Assume that all keys are positive integers,and return 0 if the list is empty

I need to have 100 story points out of an available 300 from the backlog which is in the documents uploaded. I have a starting code with GUI with some basic functions available which can be downloaded from this link.(BusinessLogic3 and UserInterface3)

You have clean and build the BL file first then the GUI file before running the application.

I can provide more details if this is something you’re confident in doing and have experience.  i expect this to take roughly 20 hours fo work so works out at $25 per hour.

Thank You