🔒 Closed Database forms

Status
Not open for further replies.

_KaNeKi_

Eternal Poster
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).webp
 
Start with Login.
Homepage.

Di ko mawari anong purpose ng system mo ano pla title nyan?
Payroll System?
 
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?
 
Status
Not open for further replies.

About this Thread

  • 23
    Replies
  • 1K
    Views
  • 5
    Participants
Last reply from:
-_Chimps_-

Online now

Members online
395
Guests online
1,540
Total visitors
1,935

Forum statistics

Threads
2,275,513
Posts
28,963,776
Members
1,232,826
Latest member
Daniella
Back
Top