1. A software company has the following information about its cl
1.Asoftware company has the following information about its clients and theprojects given by them: Clients (client number, client name, address) Projects(projectnumber, project name, total investment, no. of people working on theproject) Client project(client number, project number, date of startof project) Create a database with the tables given above. Give suitablefield names, keys and validation checks. Createdata entry forms and enter at least 10 rows.
Run thefollowing queries on the above database: a)List details of projects startedafter 1st January 2006. b)List clients who have assigned morethan 2 projects to the software company. c)List clients in order of decreasingtotal project investment. d)Show the details of the projectwith the maximum number of people working onthe it.
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!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
You can contact the company and ask if they could provide you with it, if they cannot you could always use a reliable free antivirus such as Microsoft Security Essentials, AVG, Avira Antivirus, or Avast!. Good luck!
From client pc
1.) click start
3.)in the box that opens, type cmd
4.)click ok button
A black box will appear
5.) type ipconfig
6.)press the enter key
Some lines of text will appear. One of these lines says IP Address please take note of the numbers to left of this. This is your Clients IP address
Now, you said your server IP address is 192.168.1.2 and lets say from the instructions I just gave you that you find your client IP address is 192.168.2.5. If your client pc does not have an IP address that begins with 192.168.1 it will not see your server. Also, If your client pc in question has an IP address the same as another one of your client pc's it will not see a server.
I suggest the following.
Change the IP address on your client pc following these steps
From the desktop of the client pc
2.)open control panel
3.)double click Network Connections
4.)right click Local Area Connection (it is possible to have more than one)
5.)left click properties
6.)a window will open, in the middle of this window is box you can scroll down in, scroll down and find TCP/IP
7.) left click on TCP/IP to highlight it
8.)once highlighted click the properties buttton just below the scroll box.
9.)another window will open
10.)click the dot next to Use the following IP Address
11.) enter the following
IP Address = 192.168.1.??? (replace question marks with a number of your choosing. Just dont go above 254 and don't use a number that you are using on your other pc's)
Subnet Mask = 255.255.255.0
Gateway = 192.168.1.2
12.) click ok
13.) click ok on any other open windows and reboot PC. then test connectivity.
PLEASE NOTE: There are alot of things that can change what you need to enter for the Gateway, Subnet Mask and IP address. Generally with simple networking it is what i have described above but if you have a Cable/DSL router for internet or wireless router then the numbers you must put in these fields changes. The directions I gave you above is assuming that you just want to get your pc talking to your server. It does not take into account any routers or advanced networking equipment. If you do have a router I will need more info and a somewhat different set of directions will apply.
if need to access the device of your client,just follow the steps.
we take cd rom for eg to access.
1.right click the drive there you see "sharing and security"
2.click on the and enable share as cd rom.and give maximum allowed.
3.then from your system.Run->ip of the machine->enter.
4.it shows all the share file of the client machine
if want access remote desktop
1.enable the remote desktop connection in the remote machine
2.in RUN type MSTSC the remote desktop connection will popup.
3the type the ip of the client machine