Author Question: One important relational design principle is that: A) every determinant must be a candidate key. ... (Read 33 times)

stephzh · **on:** Jul 7, 2018

One important relational design principle is that:

A) every determinant must be a candidate key.
B) every candidate key must not be a determinant.
C) every primary key must be a surrogate key.
D) every determinant must be functionally dependent on the primary key.
E) every primary key must be functionally dependent on every determinant.

Question 2

What are the common differences between a Web database processing system running on the Windows operating system and one running on a Linux operating system?

What will be an ideal response?

Sammyo · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

A

Answer to Question 2

If a Web server is running the Windows operating system, the Web server software will usually be Internet Information Services (IIS) and the Web pages may use ASP pages to integrate application logic with HTML. If a Web server is running the Linux operating system, the Web server software will usually be Apache, the database will typically be MySQL, and the Web pages may use PHP and Pearl to integrate application logic with HTML. This combination is called LAMP. Note that Apache, MySQL and PHP/Pearl can run on a Windows systems, in which case the combination is referred to as WAMP.