Question about Computers & Internet

1 Answer

Consider the following relations concerning a driving school. The primary key of each relation in bold. Student (st_id, class#, th_mark, dr_mark) Student_Driving_Teacher (st_id, dr_t_name) Teacher_Theory_Class (class#, th_t_name) Teacher__vehicle (dr_t_name, license#) Vehicle (license#, make, model, year) A student takes one theory class as well as driving lessons and at the end of the sessions receives marks for theory and driving. A teacher may teach theory, driving or both. Write the following queries using SQL. (i) Find the list of teachers who teach theory and give driving lessons on all the vehicles. (ii) Find the list of students who are taught neither theory lessons nor driving lessons by T1 (Teacher) (iii) Find the list of students who have better marks than S1 (Student) in both theory and driving (iv) Find the list of teachers who can drive all the vehicles

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 281 Answers

I'm gonna do you a favour and tell you that you need to go back and study harder. Asking someone to give you an answer to your school work is not going to help you learn SQL.

Hint. Find the common fields on all the tables involved by using SELECT JOINs

Posted on Mar 12, 2017

Ad

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad
makadimic
  • 8 Answers

SOURCE: hi.......!

i dont know wat you mean ,man ?

Posted on Dec 21, 2008

  • 3 Answers

SOURCE: i dont know anything about vb and my teacher has given me big pro

There are many online help sites available especially for Visual Studio. One of my favorites (which happens to be free) is www.planet-source-code.com. Professionals and begginners alike post code they have created for the community. There is a comprehensive search tool to find examples of code that could prove to be helpful to you.

Posted on Mar 27, 2009

log2gv
  • 10 Answers

SOURCE: my teacher give us assignment..the question is

Word is the most popular word-processing program in 2009 not only because of the marketing juggernaut that is Microsoft, but because it simplifies document creation. The program is simple enough to make quick personal letters and comprehensive enough to produce complex technical manuals.

WYSIWYG
1. What You See Is What You Get (WYWIWYG) with Word. The Word document on the screen looks exactly like the printed version, which saves time and effort in defining the appearance of the hard copy. With Word, you can view hidden fields and formatting codes, and change bars to help in creating the document. To see what the final will look like, all you have to do is to turn all these options off and view the document in "Print Layout" view.
Custom Interface
2. You can customize the look and feel of Word so it fits exactly the way you work. You can add, change or move toolbars to any part of the screen. Menu commands can be similarly managed. Text entry guides such as the status bar, scroll bars, rulers and screen tips can be turned on and off as needed.
Flexible Documents
3. Because Word is the PC's dominant word-processing program, its document format can be opened directly by or easily imported into external programs such as Adobe Pagemaker and Corel WordPerfect. Conversely, Word can easily bring in many types of file formats, including pictures and sound.
Tables
4. Word offers many ways to create tables, by specifying the number of rows and columns in a form or by dragging a single cell into several. However, the most intuitive method involves a pencil icon. By moving this pencil on the screen, you can draw the full table, create cells of varying sizes and specify borders of different colors and thicknesses.
Macros
5. Macros feature one-click access to complicated and repetitive text by recording keystrokes you can then assign to a menu option, key code or button. Whenever you need to repeat the entry, simply choose the menu option or click the macro button. More complicated macros, programmed in a subset of Visual Basic, can duplicate functions of stand-alone programs with dialog boxes, forms and data checking.
Automation
6. Word automates many previously mundane tasks. You can check and correct spelling and grammar as you type. Text in headers and footers can automatically change to reflect new chapter titles or section numbers. After you define Table of Contents formats and text references, the page numbers of those features automatically update whenever you generate a printed copy.


Posted on Jul 07, 2010

farmerbear
  • 490 Answers

SOURCE: I have licensed key of

Howdy, that program mostly shipped on new PCs a number of years ago. I am not aware of ever seeing it anywhere else. Sorry:(
farmerbear

Posted on Sep 03, 2010

waqasriaz76
  • 93 Answers

SOURCE: my teacher ask me to

http://www.ehow.com/how_6780861_make-scientific-calculator-visual-basic.html

Posted on Dec 11, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I'm writing children books and need help to find someone who can make some drawings related to the story, any suggestions?


Go to your local Jr college or high school an contact the arts teacher. Tell her what you want an the student that co Es up with the idea you are looking for will get $100 or whatever you decide. Plenty of poor school students an starving artis.good luck

Jul 18, 2017 | Books

5 Answers

What is the purpose of School Education Minister?


The School Education Minister plays the important role for the student. Ministry of school education provides the scholarship to needy and poor student and also provides the better education system.
Get More Details: Kedar Kashyap Cabinet Minister State of Chhattisgarh

Oct 19, 2015 | Computers & Internet

1 Answer

Log into a student google drive account


Normally, there is a channel where u can log in directly by accessing the school's official webpage. In addition, you can also log in with the user name as xxxx(student ID)@student.XXuniversity(school's name).edu.com

Jan 16, 2015 | Google Computers & Internet

1 Answer

Outcome of Court case concerning Brother Jack Davis, St. Mary's College, Southampton, UK


I was wondering that myself? And I wonder what became of some of the other perverts and sadists calling themselves "brother" at St Marys College Southampton, UK - such as Brother Thomas?

Feb 11, 2014 | Televison & Video

1 Answer

I meed activation key for ilumina gold premium starter


I do not have any detailed idea about the related query but should try to concern some professional for the related problem.
Should try to go through http://www.sunshineprofits.com

Aug 17, 2013 | Id Software iLumina Gold Em Portugu?s -...

2 Answers

What is the difference between a subsidized and nonsubsidized loan?


The subsidized loans are for students that can prove they do not have enough income to pay for school. The unsubsidized loan is not always need based. Often it is given as a reward or incentive to get students to attend a particular school.

Aug 14, 2013 | Finance

1 Answer

Hl-st-st dvd ram gh22lp20 ata device is not appearing on my computer


Click start control panel administrative tools computer management device manager scroll down cd-dvd rom drives you might see a yellow question mark ? right click you will have options to update driver,roll back driver,or select properties general troubleshoot, select driver click to reinstall drivers click update driver or uninstall then reinstall if this does not fix the problem it might be a registry problem if you cant see your disk drive in windows explorer
Close all open programs

Click on Start, Run, and type regedit and press Enter
Click on the plus signs (+) next to the following folders

HKEY_LOCAL_MACHINE

SYSTEM

CurrentControlSet

Control

Class

{4D36E965-E325-11CE-BFC1-08002BE10318}

This folder is the DVD/CD-ROM Drive Class Description in the registry. Look for any of the following names in the right hand column.

Upper Filters

Lower Filters

Upper Filters.bak

Lower Filters.bak

If any of the above keys shown in step 4 are listed, right-click on them and choose Delete

After deleting the keys, close the registry editor
Reboot your computer

Open My Computer and check to see if your CD or DVD drives have returned. You may also want to open Device Manager and verify that the yellow exclamation and error code on the CD or DVD drive is gone.

hope this helps you

Oct 06, 2011 | Computers & Internet

1 Answer

HL-DT-ST DVDRAM GSA-T20N IS MISSING OR CORRUPTED ( CODE 39)


Hi,

1) Close all open programs

2) Click on Start, Run, and type REGEDIT and press Enter

3) Click on the plus signs (+) next to the following folders
  • HKEY_LOCAL_MACHINE
  • SYSTEM
  • CurrentControlSet
  • Control
  • Class
  • {4D36E965-E325-11CE-BFC1-08002BE10318}
4) This folder is the DVD/CD-ROM Drive Class Description in the registry. Look for any of the following names in the right hand column.

  • UpperFilters
  • LowerFilters
  • UpperFilters.bak
  • LowerFilters.bak
5) If any of the above keys shown in step 4 are listed, right-click on them and choose Delete

6) After deleting the keys, close the registor editor


7) Go Device manager right click on Computer (Vista) -go to properties left hadside Device manager

click the + on the CD DVD drive you will find the you find the exclamation mark right uninstall that driver and Reboot your system and the issue was resolve .

May 18, 2009 | Acer Computers & Internet

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

75 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...