Question about Computers & Internet

Open Question

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

2 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

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

P0303 Flashing Service Engine Light when driving


P0303 ignition misfire on cylinder #3.
Possible Causes:

1.Fuel injectors, related wiring, sensors, computer issues
2. Running out of gas, or poor fuel quality
3. Evaporative emissions system (EVAP) concerns: fuel vapors leaking into engine
4. Incorrect Fuel Pressure
5. EGR system concerns: leaking EGR valve or restricted ports
6.Base engine concerns: low compression, valve train problems and timing issues
7. Ignition system concerns including, but not limited to:
Faulty spark plugs
Faulty coil or related wiring
Ignition module or related wiring issues
Ignition related sensor faults or wiring issues

You will have diagnose each element until you find root cause.
And it could be more than one element faulting out.
You

Jan 27, 2015 | 2002 Nissan Pathfinder

1 Answer

P0302 and low coolant


Hi there:

DTC P0302 - Misfire Detection Monitor - Cylinder 2 Misfire

A misfire is nothing more than a lack of combustion, which can be caused by poor fuel quality or metering, low compression, lack of spark or unmetered air entering the engine. There are other possible, less obvious causes as well, such as uncommanded Exhaust Gas Recirculatin (EGR), flow.

Other possible causes:
* Fuel injectors, related wiring, sensors and computer issues
* Running out of gas, or poor fuel quality
* Evaporative emissions system (EVAP) concerns: fuel vapors leaking into engine
* Incorrect Fuel Pressure
* EGR system concerns: leaking EGR valve or restricted ports
* Base engine concerns: low compression, valve train problems and timing issues
* Ignition system concerns including, but not limited to:
- Faulty spark plugs
- Faulty coil or related wiring
- Ignition module or related wiring issues
- Ignition related sensor faults or wiring issues

Hope this helps.

Apr 29, 2013 | 2005 Pontiac Grand Am

1 Answer

Strike A1 key to start PC


is the hard drive ide or sata, enter bios and disable all hard drives in the configuration with the exception of the primary. you could also try to change the sata configuration from ahci to the other option.. i can't remember what it is off hand.

May 05, 2012 | Computers & Internet

1 Answer

My 98 sonoma truck runs but lacks power with service engine soon light on .trouble code reads po300 cylinder misfire detected (random) what dose this mean


See also: P0300 diagnostic code @ OBD-Codes.com
Possible Causes:
Fuel injectors, related wiring, sensors and computer issues
Running out of gas, or poor fuel quality
Evaporative emissions system (EVAP) concerns: fuel vapors leaking into engine
Incorrect Fuel Pressure
EGR system concerns: leaking EGR valve or restricted ports
Base engine concerns: low compression, valve train problems and timing issues
Ignition system concerns including, but not limited to:
Faulty spark plugs
Faulty coil or related wiring
Ignition module or related wiring issues
Ignition related sensor faults or wiring issues

Mar 13, 2011 | GMC Sonoma Cars & Trucks

1 Answer

I have acer aspire one, runingning win xp, all drivers are ok, everithing is correctly installed, not once but 5 times, and computer is running real hard, and lock`s up a bit almoast with every command for...


Hi, I do understand your concern and how painful it is to have the notebook hang at you in the middle of a process.As you have tried installing the drivers several times this is not an issue related with any of the drivers on the computer and it could be either Windows related or else it would be surely to be an issue with the hard drive.If incase you have restored the computer to factory settings(by tapping on the Alt+F10 keys simultaneously as soon as you power on your computer and following the instructions of the Acer erecovery Management) then please do contact Acer if the laptop is covered by warranty to get the repair done or have the hard drive replaced.However incase the warranty has expired please do contact a local technician who would be able to assist you replace the hard drive. Thank you for your time and best wishes for your effort.

Jan 06, 2011 | Acer Aspire One PC Notebook

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...


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

Mar 12, 2017 | Computers & Internet

1 Answer

I have to put key in gearshift put carin nutrail start it then take off in 2nd and drive in d3 it will not shift out of park if key is in ingition


It is/or related to your Shift Interlock Solenoid.

Check the following fuses on the inside fuse box labeled: #1, it should be a 10 amp

Then check #25, it should be a 20amp

Hope that does it. If not, consider replacing the interlock solenoid.


Feb 21, 2010 | 1992 Honda Accord

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

1 Answer

Dodge ram 1500 studdars a little bit between 35 and 45 mph


A misfire on # 8 Cylinder which can be caused by poor fuel quality or metering, low compression, lack of spark or unmetered air entering the engine. 
There are other possible, less obvious causes as well. 
Fuel injectors, related wiring, sensors and computer issues
Running out of gas, or poor fuel quality
Evaporative emissions system (EVAP) concerns: fuel vapors leaking into engine
Incorrect Fuel Pressure
EGR system concerns: leaking EGR valve or restricted ports
Base engine concerns: low compression, valve train problems and timing issues
Ignition system concerns including, but not limited to:
Faulty spark plugs
Faulty coil or related wiriing

I would get the Dyno tuned and see what the computer is reading 35 and 45 MPH. or you could check with your local dodge dealer to see if there was a recall or update on the Computer if there was or is any issues. 
Good luck and hope this helps, Old School was so much easier.

Apr 09, 2009 | 2005 Dodge Ram 1500

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

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

Related Topics:

71 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...