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, 22.06.2019 01:00

)a grad student comes up with the following algorithm to sort an array a[1..n] that works by first sorting the first 2/3rds of the array, then sorting the last 2/3rds of the (resulting) array, and finally sorting the first 2/3rds of the new array. 1: function g-sort(a, n) . takes as input an array of n numbers, a[1..n] 2: g-sort-recurse(a, 1, n) 3: end function 4: function g-sort-recurse(a, `, u) 5: if u â’ ` â‰¤ 0 then 6: return . 1 or fewer elements already sorted 7: else if u â’ ` = 1 then . 2 elements 8: if a[u] < a[`] then . swap values 9: temp â† a[u] 10: a[u] â† a[`] 11: a[`] â† temp 12: end if 13: else . 3 or more elements 14: size â† u â’ ` + 1 15: twothirds â† d(2 â— size)/3e 16: g-sort-recurse(a, `, ` + twothirds â’ 1) 17: g-sort-recurse(a, u â’ twothirds + 1, u) 18: g-sort-recurse(a, `, ` + twothirds â’ 1) 19: end if 20: end function first (5 pts), prove that the algorithm correctly sorts the numbers in the array (in increasing order). after showing that it correctly sorts 1 and 2 element intervals, you may make the (incorrect) assumption that the number of elements being passed to g-sort-recurse is always a multiple of 3 to simplify the notation (and drop the floors/ceilings).

Answers: 3

Answer

Computers and Technology, 22.06.2019 11:30

Communication is the exchange of information. true false

Answers: 2

Answer

Computers and Technology, 22.06.2019 22:30

Write a full class definition for a class named player , and containing the following members: a data member name of type string .a data member score of type int .a member function called setname that accepts a parameter and assigns it to name . the function returns no value.a member function called setscore that accepts a parameter and assigns it to score . the function returns no value.a member function called getname that accepts no parameters and returns the value of name .a member function called getscore that accepts no parameters and returns the value of score .this is what i have, aparently this is wrong: class player{private: string name; int score; public: void player: : setname (string n){name =n; }void player: : setscore (int s){score = s; }string player: : getname (){return name; }int player: : getscore (){return score; }};

Answers: 2

Answer

Computers and Technology, 24.06.2019 01:00

What are two ways to access the options for scaling and page orientation? click the home tab, then click alignment, or click the file tab. click the file tab, then click print, or click the page layout tab. click the page layout tab, or click the review tab. click the review tab, or click the home tab?

Answers: 2

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