Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

307116527 bLab Instructions: You should we X C Solved Lab Instructions You ShX mn-us-east-1-prod-fleetO2-xythos.content.blackboardcdn.com/5deff73789169/71165277X-Blackboard-Expirat + t Pageview | A Read aloud Draw Highlight CST 235

image text in transcribed
image text in transcribed
307116527 bLab Instructions: You should we X C Solved Lab Instructions You ShX mn-us-east-1-prod-fleetO2-xythos.content.blackboardcdn.com/5deff73789169/71165277X-Blackboard-Expirat + t Pageview | A Read aloud Draw Highlight CST 235 Lab 3 Lab Instructions: You should work individual for this assignment. Create a new SOL script file using Notepad or Notepad++) and save it as Lab3xxxx. (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file. Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate N Professor Teachers me M Students Els Courses 100 has Sot Grading Categories Grading Schema Gruling Activities . o Lab Instructions: You should work individual for this assignment Create a new SQL script file using Notepad or Notepad++) and save it as Lab3xxxx sql (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file. Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate. ame 10 N Professor Teacher ON mester ID Credits id Sudents Enrolls Courses Course del has Submit M Grading Categories THE GradingSchema outo Tottele Grading Activities title max Point 307116527 bLab Instructions: You should we X C Solved Lab Instructions You ShX mn-us-east-1-prod-fleetO2-xythos.content.blackboardcdn.com/5deff73789169/71165277X-Blackboard-Expirat + t Pageview | A Read aloud Draw Highlight CST 235 Lab 3 Lab Instructions: You should work individual for this assignment. Create a new SOL script file using Notepad or Notepad++) and save it as Lab3xxxx. (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file. Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate N Professor Teachers me M Students Els Courses 100 has Sot Grading Categories Grading Schema Gruling Activities . o Lab Instructions: You should work individual for this assignment Create a new SQL script file using Notepad or Notepad++) and save it as Lab3xxxx sql (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file. Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate. ame 10 N Professor Teacher ON mester ID Credits id Sudents Enrolls Courses Course del has Submit M Grading Categories THE GradingSchema outo Tottele Grading Activities title max Point

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started