The primary key is the candidate key that is selected to identify tuples uniquely within a relation. A foreign key is an attribute or set of attributes within one relation that matches the candidate key of some (possibly the same) relation.
kevowmuchiri answered the question on July 4, 2018 at 15:33
- Discuss the properties of a relational table. (Solved)
Discuss the properties of a relational table.
Date posted: July 4, 2018. Answers (1)
- Discuss the advantages and disadvantages of DBMSs.(Solved)
Discuss the advantages and disadvantages of DBMSs.
Date posted: July 4, 2018. Answers (1)
- Describe the functions that should be provided by a modern full-scale multi-user DBMS.(Solved)
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
Date posted: July 4, 2018. Answers (1)
- Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.(Solved)
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.
Date posted: July 4, 2018. Answers (1)
- Describe the five components of the DBMS environment and discuss how they relate to each other(Solved)
Describe the five components of the DBMS environment and discuss how they relate to each other
Date posted: July 4, 2018. Answers (1)
- Describe the main characteristics of the database approach.(Solved)
Describe the main characteristics of the database approach.
Date posted: July 4, 2018. Answers (1)
- Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence
(Solved)
Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence
Date posted: July 4, 2018. Answers (1)
- Outline four types of memory as used in data structures(Solved)
Outline four types of memory as used in data structures.
Date posted: July 3, 2018. Answers (1)
- Define Data structures(Solved)
Define Data structures.
Date posted: July 3, 2018. Answers (1)
- Explain the difference between nominal and real gross domestic product (GDP). (Solved)
Explain the difference between nominal and real gross domestic product (GDP).
Date posted: July 3, 2018. Answers (1)
- Explain how an interactive DVD can be used to train users of an information system(Solved)
Explain how an interactive DVD can be used to train users of an information system
Date posted: July 3, 2018. Answers (1)
- An interactive DVD can be used to provide training. Describe how data is written onto a DVD.(Solved)
An interactive DVD can be used to provide training. Describe how data is written onto a DVD.
Date posted: July 3, 2018. Answers (1)
- Explain how auditing software is used on a computer network(Solved)
Explain how auditing software is used on a computer network
Date posted: July 3, 2018. Answers (1)
- Communication standards are required when data is transmitted over a network.
Explain the need for communication standards(Solved)
Communication standards are required when data is transmitted over a network.
Explain the need for communication standards
Date posted: July 3, 2018. Answers (1)
- Most organisations have replaced standalone computers with a network. Identify three advantages of a network over standalone computers.
(Solved)
Most organisations have replaced standalone computers with a network. Identify three advantages of a network over standalone computers.
Date posted: July 3, 2018. Answers (1)
- Describe the role of the programmer during software development.(Solved)
Describe the role of the programmer during software development.
Date posted: July 3, 2018. Answers (1)
- Explain the main difference between evolutionary prototyping and throw-away prototyping.(Solved)
Explain the main difference between evolutionary prototyping and throw-away prototyping.
Date posted: July 3, 2018. Answers (1)
- An organisation requires a new information system. A feasibility study is carried out. Explain what is meant by
Legal feasibility
Social feasibility(Solved)
An organisation requires a new information system. A feasibility study is carried out. Explain what is meant by
Legal feasibility
Social feasibility
Date posted: July 3, 2018. Answers (1)
- Describe how real-time processing could be used to process orders on the website.(Solved)
Describe how real-time processing could be used to process orders on the website.
Date posted: July 3, 2018. Answers (1)
- A company sells health products at a number of shops throughout the country.
An ICT consultant recommends that the company should develop a website.
Describe...(Solved)
A company sells health products at a number of shops throughout the country.
An ICT consultant recommends that the company should develop a website.
Describe two benefits to the company of using the website to sell its products.
Date posted: July 3, 2018. Answers (1)