normalization - How do i normalise this database? -
i learning database design , having problem grasping different steps of normalisation. can simple ones problem trying solve making me hit brickwall.
i creating database records jobs created user initiating transfer of files 1 ftp host another. each ftp host can have multiple folders available shared. these attributes have come -
- job id
- date created
- source host id
- source folder id
- destination host id
- destination folder id
- frequency
- start date
- finish date
- status
- comments
- user id
- first name
- last name
- password
- user access level
- ftp host id
- location name
- status
- folder id
- folder location
- folder access level
- file id
- file name
- file size
- file date created
- file date modified
i know @ least have job, ftp host, folders, files , users tables. cannot seem work out how normalise it, due having source , destination host id/folders being same host id/folders. show me in 1nf/2nf/3nf? appreciate it!
Comments
Post a Comment