Computers and Technology, 24.03.2020 02:32 carriecarl3530

By now you should have an understanding of how relational databases work and how to use SQL to create and manipulate data. Now it’s time to put that knowledge into practice. For your semester project, you are going to create a database that you might find at a college. You will be building this database from the ground up so you have many decisions to make such as naming conventions, how to organize data, and what data types to use.

Deliverables:

Document “Relationship report” showing
Table names used in the database
Table relationships
Keys
Table Fields names
Field Data types
Constraints
SQL (code) to create the following
Faculty contact list
Course Book List by Semester
Course Schedule by semester
Student Grade Report by semester
Faculty Semester grade report (number of A's, B's, C's, D's, F's per course)
Student GPA report by semester and overall (semester and cumulative)
Mailing list for Diplomas
Student Demographics over time (how many were under 18 last year, this year)
Sample query output (at least 10 entries per query)
Faculty contact list
Course Book List by Semester
Course Schedule by semester
Student Grade Report by semester
Faculty Semester grade report (number of A's, B's, C's, D's, F's per course)
Student GPA report by semester and overall (semester and cumulative)
Mailing list for Diplomas
Student Demographics over time (how many were under 18 last year, this year)

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 23:30

The keyboard usually has six rows of keys. which of the following is not one of the key group categories? letter keys number keys control keys graphic keys

Answers: 1

Answer

Computers and Technology, 24.06.2019 03:00

Click the "draw structure" button to activate the drawing utility. draw two diastereomers of (1z,4r)−1,4−dimethylcyclodecene and name them, including (e)/(z) and (r)/(s) notation. part 1 out of 4 draw the diastereomer containing a chiral center with s configuration here. window open

Answers: 1

Answer

Computers and Technology, 24.06.2019 17:00

Aman travel 200m towards east< br /> from his house then takes left< br /> to turn and moves 200 m north< br /> find the displacement & distance.< br />

Answers: 3

Answer

Computers and Technology, 24.06.2019 17:40

Pseudocode pld #6, pg. 117 start// declarations// number numbertoguess// number myguess; numbertoguess = 92// while myguess ! = numbertoguess// output " guess an integer number between 1 and 100"// input myguess// if (myguess == numbertoguess)// output "you guessed the correct number"// else// output "the number you guessed was incorrect. try again! "// end if// end while// output " for playing the guessing game. have a great day! "// stop

Answers: 3

Answer

You know the right answer?

By now you should have an understanding of how relational databases work and how to use SQL to creat...

Questions