• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Iɴғᴏʀᴍᴀᴛɪᴏɴ ᴀɴᴅ Cᴏᴍᴍᴜɴɪᴄᴀᴛɪᴏɴ Tᴇᴄʜɴᴏʟᴏɢʏ (0417) : Pᴏsᴛ ʏᴏᴜʀ ᴅᴏᴜʙᴛs ʜᴇʀᴇ! ᴴᴰ

Was this helpful


  • Total voters
    113
Messages
3,412
Reaction score
9,812
Points
523
But do you actually think our common sense WILL work once we are in the examination hall and we haven't slept and are mesmerized by the paper laying in front of us, thinking what to do?!?! At the back our minds, our parents words would be played like a background song, hoping A*s and distinctions from us.....

They won't ask this stuff. I saw the papers, they're mostly about ticking the options, true false and stuff. The main questions are from chapters 4 to 8.
 
Messages
2,538
Reaction score
17,571
Points
523
question: Describe how two files could be combine to form a relational database? (is it done with a foreign key if it is plz explain the process.
Also one advantage of why a relational database is better than having two flat files.(give a point other than data is found quicker in relational)
 
Messages
159
Reaction score
492
Points
73
question: Describe how two files could be combine to form a relational database? (is it done with a foreign key if it is plz explain the process.
Also one advantage of why a relational database is better than having two flat files.(give a point other than data is found quicker in relational)
Two or more flat files are linked together through a primary key which is also a key field in atleast one of the other files and this makes up a relational database.
Relational databases save your memory as data does not have to be copied twice (no duplication of data)
Moreover, relational databases also are quicker to update than flat files
 
Messages
110
Reaction score
166
Points
53
question: Describe how two files could be combine to form a relational database? (is it done with a foreign key if it is plz explain the process.
Also one advantage of why a relational database is better than having two flat files.(give a point other than data is found quicker in relational)

Key field or primary key is the field that is unique, and it just identifies that record for example:ISBN of a book (12 33333 345 5)
When two or more files are related together they are connected by links. Probably this link is the key field that is in the first table, and it appeared in the other table too, somehow there are connected and it is known as a foreign key since it appeared in the other table.

Advantages
Avoids data duplication
Avoids inconsistent records
 
Messages
2,538
Reaction score
17,571
Points
523
Two or more flat files are linked together through a primary key which is also a key field in atleast one of the other files and this makes up a relational database.
Relational databases save your memory as data does not have to be copied twice (no duplication of data)
Moreover, relational databases also are quicker to update than flat files
Key field or primary key is the field that is unique, and it just identifies that record for example:ISBN of a book (12 33333 345 5)
When two or more files are related together they are connected by links. Probably this link is the key field that is in the first table, and it appeared in the other table too, somehow there are connected and it is known as a foreign key since it appeared in the other table.

Advantages
Avoids data duplication
Avoids inconsistent records

thnk u both so much!
 
Top