Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show the number of students enrolled per course description for those courses having more than 10 students per course. Arrange the list by number of

Show the number of students enrolled per course description for those courses having more than 10 students per course. Arrange the list by number of students - IN ORCALE SQL image text in transcribed

APPENDIX D STUDENT DATABASE SCHEMA GRADE CONVERSION LETTER GRADE (FK) VARCHAR2(2) NOT NULL GRADE POINT NUMBER/3.2) NOT NULL MAX GRADE NUMBER(3.0) NOT NULL MN GRADE NUMBER(3.0) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRADE TYPE GRADE TYPE CODE (PN) CHAR2) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRTW_GRTYP_PK OR W GRADE STUDENT D (PK) (FK) NUMBER/80) NOT NULL SECTION ID (PKK ) NUMBER(80) NOT NULL GRADE TYPE CODE (PRK) CHAR2) NOTNI GRADE CODE OCCURRENCE (FR) NUMBER 1.0) NOT NULL NUMERIC GRADE NUMBER(3.0) NOT NULL COMMENTS VARCHAR2(2000) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED_BY VARCHAR2(30) NOT NULL MODFED_DATE DATE NOT NULL GRADE TYPE WEIGHT SECTION D (PK (FK NUMBER(8,0) NOT NULL V GRADE TYPE CODE (PKK ) CHAR/2) NOT NULL NUMBER PER SECTION NUMBER/3.0) NOT NULL PERCENT OF FINAL GRADE NUMBER(3.0) NOT NULL DROP LOWEST CHAR(1) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DA TE NOT NULL MODIFED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL GRTW_SECT_FK GR_ENR_FK ENROLLMENT STUDENT DIP)(EK) NUMBER 8.0) NOT NULL SECTION_ID (PKMFK) NUMBER(80) NOT NULL DATE NOT NULL FINAL GRADE NUMBER(30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL PNR SECT FK SECTION SECTION D(PK) NUMBER 0) NOT NULL COURSE NO (FK) NUMBER 8,0) NOT NULL SECTION NO NUMBER3.0) NOT NULL START DATE TIME DATE NULL LOCATION VARCHAR2(50) NULL INSTRUCTOR D (FK) NUMBER(8,0) NOT NULL CAPACITY NUMBER 30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED_DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL SECT_ORSE FK SECT NST FK COURSE COURSE NO (PK) NUMBER(8,0) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL COST NUMBER/92) NULL PREREQUISITE (FK) NUMBER(80) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL BNR STU FK NULL INSTRUCTOR INSTRUCTOR D(PNO NUMBER80) NOT NULL SALUTATION VARO AR215) NULL FIRST NAME VAROR225) NULL LAST NAME VARCHAR2(25) STREET ADDRESS VARCHAR2150) NULL ZP (FK) VARCHAR2(5) NULL PHONE VARCHAR2(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFIED BY VARCHAR2(30) NOT NULL MOOFIED DA TEDATE NOT NULL CRSE CRSE FK INST ZP FK STUDENT STUDENT D (PK) NUMBER(80) NOT NULL SALUTATION VARCHAROS) NULL FIRST NAME VARCHAROL25) NULL LAST NAME VARCHAR2(25) NOT NULL STREET ADDRESS VARCHAR2/50) NULL ZIP (FK) VARCHAR2(5) NOT NULL PHONE VARCHAR2(15) NULL BMPLOYER VARCHAR2(50) NULL REGISTRATION DATE DATE NOT NULLO CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL STU ZP FK ZIPCODE ZPN) VARCHAR2/5) NOT NULL CITY VARCHAR2/25) NULL STATE VARCHAR2/2) CREATED_BY VARCHAR2/30) NOT NULL CREATED DATE DATE NOT NULL MOOFED_BY VARCHAR2/30) NOT NULL MOOFED DATE DA TE NOT NULL

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

Recommended Textbook for

Implementing Ai And Machine Learning For Business Optimization

Authors: Robert K Wiley

1st Edition

B0CPQJW72N, 979-8870675855

More Books

Students also viewed these Databases questions

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago