Thread: [MySQL] database

I come to you to inform me and askfor help. I am a student in alternating first year diploma inComputer Science option network administrator for my company I hadthe idea to create a small database with various information tofacilitate the ip address.

I would like to create a databaseso I can find by typing an IP to which it belongs and vice versa inbulk (more information will follow them but I would have the basis.)

But I lack much knowledge on the subject because it is myfirst year of data. So I know use phpmyadmin, I can make tables, addfields, make requests ect. But I do not understand what is therelationship between a user who knows nothing and the database.Underway to find information I need to do my request but how does auser?

Hi,

yes he will be an interface if you want to use the data in your database from other than PHPMYADMIN. For that you'll be made a web page (PHP ...) or a program (c + +, vb ...) but in each case you must use connectors or the connecting link (connectionstring, looking on google)

To know what you have to use properly define your needs, to determine who has access to what.

Yes I'm on livron syndrome, you know?

Infact it's just the IT department that would use this database, in our policy is to assign a static IP per user, and based on that user's ip and gives him the right to access the internet ect.

And as we have no plan to address day I make a small database up to date. Sometimes you have to test a material, or install it and then put it on the network and we need an IP and it's not up to date as we do not know where to take.

In your case you can either make you a software C + + or VB for example, an interface with a map of your box and deal with BDD tt ca! you can do a lot of stuff, like a party that manages the available IP (test, ping), a party who manages the PC (you can create a good program that retrieves data from remote PC via the commands in CMD / DOS you can run in your program).

I know not at all the C, C + + or VB, and I know just a little bit of php. His interests me the program that can recover data at a distance as his can make me as a PTI.

My understanding is that wamp is not a virtual server? if I make a database with phpmyadmin Wamp's going to do the shot.

I did not, but its in a hurry was just for me / give you an idea:)

Is that like her better?

ADDRESS (ID_adressage, ip, acces_internet)
EMPLOYEE (EmployeeID, nom_emp, prenom_emp, num_intern_emp, service_emp)
COMPUTER (id_order, marque_ordi, model_ordi, os_ordi, num_ecran)
MESSAGING (ID_messagerie, adresse_mail, password)

The password will appear encrypted I think not because of my lack of expertise in this area.

I will store the IP address and MAC address not just because it interests me is the IP address in my company an IP address is assigned to an employee and that only the following IP anywhere .

Here's what I concluded:

EMPLOYEE (EmployeeID, nom_emp, prenom_emp, num_intern_emp, service_emp, adresse_mail, mot_de_passe_messagerie)
COMPUTER (id_order, marque_ordi, model_ordi, os_ordi, num_ecran, ip_long, acces_internet, addr)
SERVICE (num_service, service_name)

This is consistent for you?

For the rest, make sure that the size of your varchar fields is sufficient. 20 characters seems a little short for first and last name (even if it is true that it happens in most cases). For email address, it depends what you STORED in (local part of the address only? Full address but whose maximum size is known because of the rules of construction? Home address of contact?)

But again it seems a bit short. For example, my professional email address has 32 characters. 10 characters for the password is too little.