Page 174 - Open Soource Technologies 304.indd

Web Technologies-I

Notes
2. Draft a database outline.
The outline determines the structure of the database-what information is stored and how
different pieces of information relate to one another.
3. Check system requirements.
How you meet system requirements and define system parameters affects the efficiency
and performance of the database.
4. Load test data into the database.
After an outline and a security plan are in place, you load the database with test data
to enable the later steps of the process.
5. Define calculations.
You test outline consolidations and write and test formulas and calculation scripts for
specialized calculations.
6. Define reports.
Users access data through print and online reports and spreadsheets or on the World
Wide Web. If you plan to provide predefined reports to users, you design report layouts
and run reports.
7. Verify with users.
You want to ensure that the database satisfies your user goals. You must solicit and
carefully consider the opinions of users.
8. Repeat the process.
To fine-tune the design, you repeat steps 1 through 7.
Questions:

1. Explain the Process for Designing a Database.
2. Discuss the Multidimensional Database.

Self Assessment

Multiple choice questions:
4. The array_chunk( ) function is use to:
(a) Delete the array (b) Split the array

(c) Create the array (d) None of these.
5. The array_splice( ) function is use to:

(a) Remove elements in an array
(b) Insert elements in an array
(c) Remove or insert elements in an array
(d) None of these.

6. The array_diff( ) function is use to
(a) Differentiate between array elements.
(b) Insert elements in an array

168 LOVELY PROFESSIONAL UNIVERSITY