Question

About Databases create a new course ("CS-001", "Computer basics", "comp sci", 2), then create a new...

About Databases

create a new course ("CS-001", "Computer basics", "comp sci", 2), then create a new section of this course ("CS-001", 1, "Winter", 2018) Enroll every student in the comp sci department into this course section

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Since you have not provided the schema details, I am guessing the table and column names in order to provide the query. Hence, the query might need some modifications in order to run properly.

QUERY:

INSERT INTO course VALUES ("CS-001", "Computer basics", "comp sci", 2);

INSERT INTO section VALUES ("CS-001", 1, "Winter", 2018);

Add a comment
Know the answer?
Add Answer to:
About Databases create a new course ("CS-001", "Computer basics", "comp sci", 2), then create a new...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • II. Fill in the blanks: (30 The relational database schema of Course Management System are defined...

    II. Fill in the blanks: (30 The relational database schema of Course Management System are defined as follows: Department (ID, Name, Head) Teacher (ID, Name, Position, DeptID) Student (ID, Name, Gender, Birthday, DeptID) Course (ID, Name, Room, TeacherID) Enroll (StudentID, CourseID, Grade) Please fill the blanks in the following SQL statements. 1. Create the Enroll table. CREATE TABLE Enroll ( char (8) NOT NULL StudentID [1] char (4) NOT NULL CourseID [2] int Grade CHECK (Grade IS NULL OR (Grade>-0...

  • Hi, I need help with my comp sci assignment. The parameters are listed below, but I...

    Hi, I need help with my comp sci assignment. The parameters are listed below, but I am having trouble generating the number of occurrences of each word. Please use a standard library. Read in the clean text you generated in part 2 (start a new cpp file). Create a list of all the unique words found in the entire text file (use cleanedTextTest.txt for testing). Your list should be in the form of an array of structs, where each struct...

  • Need help with Intro to Comp Sci 2 (Python) problem: This is what is provided: (Copy/Paste...

    Need help with Intro to Comp Sci 2 (Python) problem: This is what is provided: (Copy/Paste version): from tkinter import Tk, Label, Entry, Button from random import * class Craps(Tk): #set up the main window def __init__(self, parent=None): Tk.__init__(self, parent) self.title('Play Craps') self.new_game() self.make_widgets() #when a new game is started, the firstRoll will start at 0 def new_game(self): self.firstRoll = 0    #create and place the widgets in the window def make_widgets(self): Label(self, text="Die 1").grid(row=0, column=0, columnspan=1) Label(self, text="Die 2").grid(row=0,...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • SIUNboard/do/message?action=create&do=create&requestType=thread&.course id=81238 1&navdiscussion board Laundryjobs Jobs in... Sounds of blacknes... New Jersey Labor TDI New Jersey...

    SIUNboard/do/message?action=create&do=create&requestType=thread&.course id=81238 1&navdiscussion board Laundryjobs Jobs in... Sounds of blacknes... New Jersey Labor TDI New Jersey Labor. New Tab Search .. Due Wednesday at 11:59 pm EST. You Step 1: Read the Discussion Background: Mike is a youth worker at the YMCA. He plans afterschool programs for youth Mike noticed a white teenager bullying an African-American teenager by shouting derogatory racial comments at him. Mike was concerned about this, and he sees a need to teach the bully how to...

  • I need help for part B and C 1) Create a new project in NetBeans called...

    I need help for part B and C 1) Create a new project in NetBeans called Lab6Inheritance. Add a new Java class to the project called Person. 2) The UML class diagram for Person is as follows: Person - name: String - id: int + Person( String name, int id) + getName(): String + getido: int + display(): void 3) Add fields to Person class. 4) Add the constructor and the getters to person class. 5) Add the display() method,...

  • Jubail University College Computer Science & Engineering Department Assessmen Assignment Course Code CS120/C5101 t Type: 1...

    Jubail University College Computer Science & Engineering Department Assessmen Assignment Course Code CS120/C5101 t Type: 1 Semester: 403 Course Title Programming Submission 27-06-2020 Total Points 8 Date Submission Instructions: • This is an individual assignment. • Please submit your program (Java fle) in Blackboard. You can create one java project, named as Assignment1_id and add separate java file for each question. You can name your javá files as 01.02.... etc. • Make sure that you include your student ID name...

  • Laundryjobs Jobs in. message?action=create&do=create&requestType=thread&course_id: 81260 1&nava discurso Bord Sounds of blacknes... New Jersey Labor TD New...

    Laundryjobs Jobs in. message?action=create&do=create&requestType=thread&course_id: 81260 1&nava discurso Bord Sounds of blacknes... New Jersey Labor TD New Jersey Labor. New Tab Search Follow the 3-Step Plan and Student Checklist to meet the Discussion Grading Rubric expectations Due Wednesday at 11:59 pm EST. Step 1: Read the Discussion Background: According to Goleman (1995), emotional intelligence (El) is the ability to recognize your own emotions, the emotions of others and how they influence our lives (either positively or negatively). We have all experienced...

  • Help with database creation - create a visio ER diagram of the scenerio below.. thanks The...

    Help with database creation - create a visio ER diagram of the scenerio below.. thanks The registrar's office at Weber State University wants you to create a new database to support an future application that will help their department better keep track of the scheduled classes offered each semester, including the specific course sections and lecturers appearing in the schedule, and the students registering for courses according to the published schedule. Courses (think course catalog) may or may not be...

  • 1) Create a struct called CourseInfo to store info about a course (Include variables for courseNum,...

    1) Create a struct called CourseInfo to store info about a course (Include variables for courseNum, courseName, & grade) 2) Change the type for the 'data' member variable in the node struct to CourseInfo (see #1) and rename it to 'courseData' 3) Modify the createNode function to receive a CourseInfo struct as a parameter. It should also display the address of the new node that is created. Display the address in both hex and decimal form. 4) Modify the display...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT