Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.
Reflection paper/Reflection essay
27/08/2022
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
StudentIDint
FirstNamestring
LastNamestring
BirthDatedate
Genderstring
StartDatedate
GPAnumber
IsActiveboolean
Biostring
AdvisorIDint
Advisors
AdvisorIDnumber
FirstNamestring
LastNamestring
EmailAddrstring
Classes
ClassIDint
ClassCodestring
ClassNamestring
Descriptionstring
Students_Classes
StudentClassIDint
StudentIDint
ClassIDint
StartDatedate
Assignment1number
Assignment2number
Assignment3number
Assignment4number
ClassGPAnumber
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. The datatype bit can be used for Boolean fields.
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.
Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more