🔒 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_-

Trending Topics

Online now

Members online
1,040
Guests online
1,526
Total visitors
2,566

Forum statistics

Threads
2,294,932
Posts
29,094,144
Members
1,206,613
Latest member
cheeseterrific
Back
Top