• 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
Dark Destination

Dark Destination

Messages
3,412
Reaction score
9,812
Points
523
Layla.. said:
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.....
Click to expand...

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.
 
Lola_sweet

Lola_sweet

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)
 
L

Layla..

Messages
159
Reaction score
492
Points
73
Lola_sweet said:
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)
Click to expand...
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
 
Shada Mohammed

Shada Mohammed

Messages
110
Reaction score
166
Points
53
Lola_sweet said:
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)
Click to expand...

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
 
Lola_sweet

Lola_sweet

Messages
2,538
Reaction score
17,571
Points
523
Layla.. said:
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
Click to expand...
Shada Mohammed said:
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
Click to expand...

thnk u both so much!
 
You must log in or register to reply here.
Top