What's new

Databases Database forms

_KaNeKi_

Eternal Poster
Joined
Jan 15, 2017
Posts
921
Solutions
1
Reaction
151
Points
438
Age
24
Mga master ano ano ang mga forms ang gagawin ko dito sa database model na to? Gagawa pa ba ako log in form? Sana po may makatulong. Need ko lang po asap.
images (25).jpeg
 

Attachments

Start with Login.
Homepage.

Di ko mawari anong purpose ng system mo ano pla title nyan?
Payroll System?
 
Start with Login.
Homepage.

Di ko mawari anong purpose ng system mo ano pla title nyan?
Payroll System?
employee record management system po.

Sir sa login form: username at pass lang??

Tapos ano ano laman ng homepage?
 
Payroll System po yang gnagawa nyo. for sure jan papunta yan pag nkita ng mga prof mo.
 
maraming mali yung mga gnawa mo sa taas. before ka mag lagay ng Foreign Key dapat may default key sila.


Simplify mo lahat. pra madali.
Employee - All basic personal Information
Employee_ID
FullName. format style. Lastname, Firstname Middlename
Gender
BirthDate
Age
Complete Address. format style. Block, Streetname, City Address
Contact#
Status. ex. married, single

ex. implementation.
Unique ID - Phone_ID
Foreign Key - Employee_ID.

ksi yung I reiretrieve mo yung contact ni employee gagamitin mo yung id ni Employee. kung nsa kabilang table sya ganito.

query.
select * from Phone where Employee_ID = 1
 
maraming mali yung mga gnawa mo sa taas. before ka mag lagay ng Foreign Key dapat may default key sila.


Simplify mo lahat. pra madali.
Employee - All basic personal Information
Employee_ID
FullName. format style. Lastname, Firstname Middlename
Gender
BirthDate
Age
Complete Address. format style. Block, Streetname, City Address
Contact#
Status. ex. married, single

ex. implementation.
Unique ID - Phone_ID
Foreign Key - Employee_ID.

ksi yung I reiretrieve mo yung contact ni employee gagamitin mo yung id ni Employee. kung nsa kabilang table sya ganito.

query.
select * from Phone where Employee_ID = 1
Sir salamat sa mga corrections. Sir pano po yung gui neto?
 

Similar threads

Back
Top