Question: SQL 1. Student Table : IFname Instr Id 2000 Ilname Ahmed gender F Wafa 2001 Hind Fahed F 2002 Asma F Abdullah Fahed 2003 Ali

SQL 1. Student Table : IFname Instr Id 2000 Ilname Ahmed

gender F Wafa 2001 Hind Fahed F 2002 Asma F Abdullah Fahed

2003 Ali M NULL NULL NULL NULL 2. Instructor Table: SFName SLName

SQL

1. Student Table : IFname Instr Id 2000 Ilname Ahmed gender F Wafa 2001 Hind Fahed F 2002 Asma F Abdullah Fahed 2003 Ali M NULL NULL NULL NULL 2. Instructor Table: SFName SLName Address BDate Gender Std_ID 1000 Ali 1988-03-08 M Ahmed Abdullah 1001 Norah F 1002 Ahmed Kamal Dammam Alkhobar Dammam Riyadh Riyadh Dammam 1990-09-08 1990-08-03 1991-09-06 M 1003 Nada Salem F 1004 Norah Ali 1991-05-06 F Nouf 1005 Nasser F 1989-05-03 1989-05-02 1006 Rana Alkhobar F Abdullah NULL NULL NULL NULL NULL NULL 3. Course Table : Inst_id Course_ld 3000 Course_Name credit_hours Database Mana... 3 2000 Business 2001 3001 3002 2002 3003 IT Proect 3 Project Proposa... 2 Technical Repo... 3 Data Mining 2003 WW NWN B004 2002 3005 2003 4. Enrolled Table : Year Could 3000 Stude_id 1000 3001 1001 2013 2012 2010 B001 1006 1002 2013 3002 3003 3003 1002 2013 2012 1003 1000 2012 2004 3004 B005 1005 2010 1004 2011 University Database Diagram: Student 9 Std_ID SFName Instructor 8 Instr_id IFname SLName Ilname Address gender BDate enrolled Could 8 Stude_id Year Course 8 Course_ld Course_Name credit_hours Inst_id 7. View all course id and instructor id their course id are 3000 or 3001. And view the minimum credit hours for each course. 8. Update the address= 'Jeddah'for all student

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In database MySQL solve the following ( 1-8) questions ((I upload two pictures)) SQL Queries: Using the University database, write following queries: 1. Student Table : IL name Instr_id 2000 IFname...

using sql SOL Omerdes: Using the University database, write following queries: 1. Student Table Frame gender Instrld 2000 2001 2002 2003 WHO Hind Ilname Ahmed Fahed Abdullah Fahed NULL Asma AR NULL F...

I have already asked this question, but the answer was quite complex in certain parts, can someone answer this in the simplest form possible with side notes on what they are doing? For example when...

Using the table description and business rules on the following page, answer or perform the following: Identify the Primary Key of the table as it is currently shown. Identify all of the functional...

Please help with this SQL Oracle lab. At least with part of it. ---------------------------------------------------------------------------------------- Normalization and Creating Tables (For this...

2 . Normalize the relation to 3 rd Normal Form ( 3 NF ) . Include progression from 1 NF to 3 NF a . List the normalized tables using the standard table notation ( Remember Chen and / or Crow s foot )...

Query 1 Student table CREATE TABLE Students ( student_id int, name varchar(255) not null , date_of_birth date, address varchar(255), email varchar(255) unique, level varchar(255) not null ,...

Refer to given table and insert into the file the implementations of the following queries as SELECT statements of SQL The queries listed below must be implemented as SELECT statements SQL 1. CREATE...

for the visit table im getting this error please tell me whay im doing wrong 3 Request edit access ] =) Proj... File Edit View Tools Help Visit Column Name VisitID Patient ID DoctorID Dateof Visit...

The Federal Reserve chose to target fed funds rate from 1970 to October 1979, and moved to targeting money supply, and moved back to targeting fed funds rates after July 1993. 1) Ceteris paribus, if...

Suppose there are three types of individuals: high productivity (HP), medium productivity (MP) and low productivity (LP). LP and MP workers amount for a proportion of sizes qL and qM of the entire...

Which of the following will be reported as a long - term liability on the balance sheet? 2 . notes payable ( due in 1 1 months ) b . accounts payable c . accrued liabilities d . none of these choices

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

9. What are some potential advantages and disadvantages of attitude-awareness-based diversity training programs?

6. The director of sales and marketing for a Warner Brothers theme park has been working in Madrid. She is getting ready to return to the United States. What should Warner Brothers do to ensure her...

11. List and discuss the steps involved in developing a succession planning system. How might a succession planning system differ between high-potential employees and employees with midlevel...