Reference no: EM131406389
The purpose of this assignment is to promote students' analytical skills in anlyzing a case scenario and utilizing the given information and resources to design an ER diagram and write SQL script.
Case Scenario
South Community College (SCC) is structured like a typical community college. They have 3 semesters and a multitude of courses. Each course may have any number of sections in a given semester. For example, CTS2437 (SQL Server) may have one or more sections being taught in any given semester. SCC has 3 semesters (fall, spring, summer) which they refer to as A, B, and C. They refer to semesters by the year and the semester code. For example, fall 2011 would be referred to as 2011A. They need to keep track of students, courses, schedules, instructors, and grades earned in each course taken. They need a database to maintain these information.
The student information would include the student name, address, phone#, and email. Students may have taken or are taking any number of courses. The grade earned for each course must also be maintained. The course information would include the course title and number of credits. Keep in mind that a given course may have many sections in any particular semester. SCC needs to maintain the instructor for each section in addition to the students and the grade they earned. The instructor information would include the instructor name, phone#, office#, and email address. South needs to maintain all courses that the instructor has taught or is currently teaching.
Some of the requirements that SCC has requested in the database system include:
- Student cannot register for the same section more than once.
- A roaster of studetns can be produced for any given section.
- GPA (Grade Point Average) can be generated for a student for any given semester, year, or entire school career.
- GPA is calculated by adding up all of the grades earned (A=4, B=3, C=2, D=1, F=0) and dividing by the number of credits associated with the courses taken.
- A transcript can be produced for a given student showing all courses taken and grades earned.
Requirement and Submission:
You are required to use any available to tool to design and develop an ER diagram and write SQL script. The accepted file formats are MS Wordor PDF file format. Please include a title page with your name and case project title. Name your file as follow: Case3_YourLastName.docx
Determining the wan network design
: For this assignment, you will create a wide area network (WAN) design. A WAN is the core component to your network, as it compasses all your local area networks (LANs) and all needed network infrastructures like routers, switches, and servers. Use..
|
Calculate the material-removal rate
: Calculate the material-removal rate, estimate the power and torque required for this operation, and calculate the cutting time.
|
What were the endpoints of this toxicity testing
: How does the information apply to what you are learning in the course? What were the objectives of this toxicity testing? What were the endpoints of this toxicity testing?
|
What is the industrial or agricultural profile of the county
: Worldwide energy consumption varies dramatically, but the impacts are shared by all. The most commonly used fuel sources for energy around the world are the fossil fuels: coal, oil, and natural gas. Combustion of fossil fuels releases pollutants t..
|
Design an er diagram and write sql script
: The purpose of this assignment is to promote students' analytical skills in anlyzing a case scenario and utilizing the given information and resources to design an ER diagram and write SQL script.
|
Maintain internet security of a website
: Write a 2-3 page paper discussing ways to maintain internet security of a website. You may use additional data sources to supplement your assessment of the case study. Use APA standards in citing your data sources.
|
Prepare a comprehensive table of the process capabilities
: On the basis of the data developed in Problem 24.54, describe your thoughts regarding the procedure to be followed in determining what type of machine tool to select when machining a particular part.
|
Which elements of total compensation would be more important
: If you were considering a job offer, which elements of total compensation would be more important to you: base pay, incentives, or benefits and services? Why? What are the implications of your answer for employers seeking to attract people like yo..
|
Permission to make changes to the file
: Show the command you would use to give the people in your group permission to make changes to the file.
|