Describe the purpose of the main steps in the physical design methodology presented in this chapter.
What will be an ideal response?
Step 3 Produces a relational database schema from the logical data model. This includes
integrity rules.
Step 4 Determines the file organizations for the base relations. This takes account of the nature
of the transactions to be carried out, which also determine where secondary indexes will
be of use. As a result of analyzing the transactions, the design may be altered by
incorporating controlled redundancy into it.
Step 5 Designs the user views for the database implementation.
Step 6 Designs the security measures for the database implementation.
You might also like to view...
________ are values that provide information concerning the action being carried out by the macro
A) Business rules B) Processing times C) Arguments D) Macros
Your mother likes to draw. She has been scanning her drawings and putting them on her computer but would like a way to draw and edit the pictures on the computer. What peripheral type would you recommend for your mother?
A. Webcam B. Touchpad C. VR headset D. Graphics tablet
What is shielded twisted pair (STP) and where is it found?
What will be an ideal response?
??Match each correct item with the statement below. ?
A. ?A WAN technology functioning primarily at Layer 2 (although its protocols can also reach Layers 1 and 3) that was originally conceived in the early 1980s at Bell Labs and standardized by the ITU in the mid-1990s. B. ?A variety of ISDN that uses two 64-Kbps bearer channels and one 16-Kbps data channel, as summarized by the notation 2B+D. C. ?The guaranteed minimum amount of bandwidth selected when leasing a frame relay circuit. Frame relay costs are partially based on this. D. ?A connectivity device located at a telecommunications carrier's office that aggregates multiple DSL subscriber lines and connects them to a larger carrier or to the Internet backbone. E. ?A special case of geosynchronous orbit in which the satellite stays directly above the equator and appears stationary from Earth. These satellites are the type used to provide satellite Internet access. F. ?A 4G cellular network technology that, in its latest version, achieves downlink data rates of up to 3 Gbps and uplink rates of up to 1.5 Gbps. G. ?A WAN technology that sends Ethernet traffic across MAN connections. H. ?A type of WAN in which each site is connected to two other sites so that the entire WAN forms a circle pattern. I. ?An intelligent type of NIU located at the customer's demarc that can provide diagnostic information about the interface. J. ?The equipment on a satellite that receives an uplinked signal from Earth, amplifies the signal, modifies its frequency, then retransmits it (in a downlink) to an antenna on Earth.