Reference no: EM13754694
You are tasked with creating the database to store information for a university of your choosing. After initial design meetings with your client, the following business rules have been determined:
A student has a name, a birth date, and gender.
You must track the date the student started at the university and his or her current GPA, as well as be able to inactivate him or her without deleting information.
For advising purposes, store the student's background/bio information. This is like a little story.
An advisor has a name and an e-mail address.
Students are assigned to one advisor, but one advisor may service multiple students.
A class has a class code, name, and description.
You need to indicate the specific classes a student is taking/has taken at the university. Track the date the student started a specific class and the grade earned in that class.
Each class that a student takes has 4 assignments. Each assignment is worth 100 points.
The following entity tables have been composed:
Students |
StudentID |
int |
FirstName |
string |
LastName |
string |
BirthDate |
date |
Gender |
string |
StartDate |
date |
GPA |
number |
IsActive |
boolean |
Bio |
string |
AdvisorID |
int |
|
Advisors |
AdvisorID |
number |
FirstName |
string |
LastName |
string |
EmailAddr |
string |
|
Classes |
ClassID |
int |
ClassCode |
string |
ClassName |
string |
Description |
string |
|
Students_Classes |
StudentClassID |
int |
StudentID |
int |
ClassID |
int |
StartDate |
date |
Assignment1 |
number |
Assignment2 |
number |
Assignment3 |
number |
Assignment4 |
number |
ClassGPA |
number |
Create a database in an SQL server, and translate this design into SQL server tables with appropriate fields. The data types above are general types. An int is an integer whole number. A number is a real number with a decimal point and fractional digits to the right of the decimal point. A string could be a single character, a few characters or even multiple paragraphs of text. Each DBMS may have several specific data types for each general type. The specific data type that you select will depend on the size and range of the values that will be stored in the field.
In the Students_Classes table, the assignment fields are used to record a grade for each of the 4 assignments in the class. Values range from 0-100. The GPA fields will store values from 0.00-4.00. In the Students table, the gender field will record an M or F.
All primary keys should be specified as "identity" or "auto-increment" fields, which means that the database management system will create a unique value for the field, each time a new row is added to the table. By default, the value starts at 1 for the first row added and increments by 1 for each new row inserted.
Your deliverable should be a Word document with the DDL script necessary to recreate all tables and relationships. Focus on proper datatypes, keys, identities, and constraints. Future assignments will depend on your design, so it is best to try and stick to the base specs. In addition to the DDL script, provide a screenshot of a diagram showing all tables and the relationships between them.
Cash dividends without impairing its capital
: Tangshan Mining has common stock at par of $200,000, paid in capital in excess of par of $400,000, and retained earnings of $280,000. In states where the firm's legal capital is defined as the par value of common stock, the firm could pay out ____..
|
Business functions and processes
: Describe the methods for establishing component priorities, including: Business functions and processes and BIA scenarios and components and Financial and service impact of components not being available
|
Compare and contrast berninis davd and michelangelos david
: compare and contrast Bernini's Davd and Michelangelo's David or Borromini's San Carlo and Bernini's St. Peter's Basilica.
|
Write a multiple regression equation t
: Write a multiple regression equation that can be used to analyze the data for a two-factorial design with two levels for factor A and three levels for factor B. Define all variables
|
Create a database in an sql server
: Create a database in an SQL server, and translate this design into SQL server tables with appropriate fields. The data types above are general types
|
Sears conducted a quality control study on the car
: Sears conducted a quality control study on the car batteries that customer purchase off of the shelf. 50 batteries are selected and it is determined that 6 are defective and 44 are functioning properly. This is a binomial experiment. Select the appro..
|
Why was rachel carson so worried about the use of ddt
: Why was Rachel Carson so worried about the use of DDT? How did her book usher in the environmentalist movement?
|
Describe the purpose of a risk assessment
: Describe the purpose of a risk assessment, risk scope and identify critical areas for an assessment. Select risk assessment methodology and give your rationale behind the one you chose.
|
Analyze the conflict between traditionalism and modernism
: Identify and analyze the conflict between traditionalism and modernism during the 1920's. Create a 2 column organizer in notes indicating manifestations of both traditionalism and modernism.
|