Please answer the following questions below with True/False: T F A popular rule
ID: 3839549 • Letter: P
Question
Please answer the following questions below with True/False:
T F A popular rule of thumb is that a design is in 3NF if every nonkey field depends on the key, the whole key, and nothing but the key. T F A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on other nonkey fields. T F Normal forms beyond 3NF exist, but they rarely are used in business-oriented systems. T F Relational databases are poorly suited to client/server computing because they are so powerless and rigid. T F Relational databases can run on many platforms, including personal computers. T F A data warehouse allows users to specify certain dimensions, or characteristics. T F In e-commerce, data mining works best when a goal is to reduce clicks to close, which means average page views to accomplish a purchase or obtain desired information. T F Logical storage is strictly hardware-related, because it involves the process of reading and writing binary data to physical media. T F A thin client design locates all or most of the application processing logic at the client. T F A three-tier design includes a middle layer between the client and server that processes the client requests and translates them into data access commands that can be understood and carried out by the server. T F The disadvantage of an application logic layer is that a three-tier design reduces overall performance by increasing the data server's workload. T F Middleware provides a transparent interface that enables system designers to integrate dissimilar software and hardware. T F As the size of a business changes, it is easier to alter the capability of a large-scale central server than it is to adjust the number of clients and the processing functions they perform.Explanation / Answer
33) True : in 3NF every nonkey field depends on key, whole key and nothing but the key.
34) False, for it to be in 3NF nonkey fields needs to depend only on key fields.
35) True, there is 4NF but rarely used in business oriented systems.
36) False, relational databases are not poorly suited to client/server computing.
37) True, relation databases can run on many platforms incluing personal computers just a group of table, schema and it can run anywhere.