IS320_Week 1 Exercise_IngramJ

[SHORTENED TITLE UP TO 50 CHARACTERS] 3 at a grade level such as first-year student, sophomore, junior, and senior, they need to attend a certain number of courses with a certain number of credited hours. 2.13: Choose a database application with which you are familiar. Design a schema and show a sample database for the application, using the notation of Figure 1.2 and 2.1. What types of additional information and constraints would you like to represent in the schema? Think of several users of your database and design a view for each. STUDENT Name Student_number Class Major Jason Ingram G00151729 4 BS Engineering Management Technology John Doe G00151730 4 BS Engineering Management Technology Courses Course_Name Course_number Credit_hours Department Engineering Economics EMT320 3 BS Engineering Management Technology Fund Prop of AC Circuit & Lab ET115 4 BS Engineering Management Technology Electronics 1 and Lab ET212 4 BS Engineering Management Technology Mental Health and Wellness SS340 3 BS Engineering Management Technology Section Section_Identifier Course_Number Semester Year Instructor 202301 EMT320 Fall 2023 Roberts 202303 ET115 Spring 2023 Hassanzadeh 202310 ET212 Fall 2023 Smith 202211 SS340 Fall 2022 Johnson