Question: 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,

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)

Step by Step Solution

★★★★★

3.41 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

For the above question we need to create table and Manipulate data So lets discuss one by one We wil... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The goal of this assignment is to learn about real-world SDLC failures and apply what we've learned about the SDLC to these "cases". I hope that, by doing this, you will not be involved with (or,...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

A car is randomly selected at a traffic safety checkpoint, and the car has 6 cylinders. Determine whether the given values are from a discrete or continuous data set.

Oki Products, Ltd., has observed the following processing costs at various levels of activity over the last 15 months: Required: 1. Prepare a scattergraph using the above data. Plot cost on the...

EXPENDITURES AFTER ACQUISITION AND DEPRECIATION Eastern National Bank installed a wireless encryption device in January 2005. The device cost $120,000. At the time the device was installed, Eastern...

2.39 A Skewed Distribution To illustrate the utility of the Empirical Rule, consider a distribution that is heavily skewed to the right, as shown in the accompanying figure. a. Calculate and s for...

Pooling information from the output design and reviewing their progress, Chip and Anna proceed to the next stage, the design of input. Web pages must be designed to capture input information easily...

A. On February 1, 2020, Asure receives information that the appraiser of BlueBox's plant and equipment was not qualified. A new appraiser values BlueBox's plant and equipment at $14,000 as of the...

The founder of Frenza asks us to assist her in accounting and analysis of the corporations bonds, which have an annual contract rate of 8%. She wants to know the business and accounting implications...

ANSWER BOTH EA10-A1 and EA10-A2 ON EXCEL SPREADSHEET Apply Your Skills diwotnd. If you don't use the eleart file, your work cannot be aunomatically gaded Complete Budgets and a CVP Analysis for Dairy...

A firm repurchases 10 percent of its outstanding common stock. What is the effect of this treasury stock transaction? O The common stock shares will be permanently retired. O Its debt-to-total...

You're working with a data source that has all of its data on a single Excel worksheet and its structure has multiple sub-tables. Which is the best way to get this data ready for analysis

Nagy Corporation reported the following income statement in 20X1, along with a comparable income statement for 20X0, its first year of operations: Income Statement, 20X1 and 20X0 ($ in millions)...

Performance of Buffet's investments. One of the stocks owned by BRK is Coca-Cola (KO) (Apparently Buffett drank five cans of Chery Coke each day!), which Buffett purchased on January 1, 1988 for...

Your employer is a social media company. According to office gossip, the company's nonexecutive chairman has not filed individual tax returns for many years. Would this matter be included within the...

he following information describes production activities of Mercer Manufacturing for the year: Actual raw materials used 26,000 lbs. at $4.70 per lb. Actual factory payroll 9,250 hours for a total of...

Marc Company assembles products from a group of interconnecting parts. The company produces some of the parts and buys some from outside vendors. The vendor for Part X has just increased its price by...

You have been asked to provide the managing director with an approximate cost function for the entitys activities, and it must be done by this afternoon. Some members of the board of directors want...

Each of the costs below is incurred by Fairgood & Hernandez, a small CPA firm. Required Identify whether each of the following costs most likely relates to an (i) organisation sustaining activity,...

Livermore Components is a supplier of drive shafts to the motor vehicle industry. Currently it supplies two of the large car manufacturers in Australia and is also highly ranked in a tender bid to...

Governments in Canada, at all levels, make considerable transfer payments to individuals and to businesses. This question will show you how significant these transfer payments are. Go to Statistics...

Fill in the blanks to make the following statements correct. a. Canada has different fiscal authorities, in the form of federal, provincial, territorial, and municipal governments. The coordination...

The diagrams below show the market for gasoline in two countries, Midas and Neptune. In Midas, demand is perfectly inelastic; in Neptune, demand is relatively elastic. In both countries, supply is...