“Database & File”

    #1. What is meant by data independence? Explain your answer.
    #2. Identify two benefits of separating application software from the database management system.
    #3. Identify the level within a database system (user, programmer of application software, and designer of the
    DBMS software) at which each of the following concerns or activities occur:
    a. How should data be stored on a disk to maximize efficiency?
    b. Is there a vacancy on flight 243?
    c. Could a relation be stored as a sequential file?
    d. How many times should a user be allowed to mistype a password before the conversation is terminated?
    e. How can the PROJECT operation be implemented?
    #4. Design a relational database containing information about music composers, their lives, and their
    compositions. (Avoid redundancies similar to those in Figure 9.4)

    Part 2:

    #1. Suppose a sequential file contains 50,000 records, and 5 milliseconds are required to interrogate an entry.
    How long should we expect to wait when retrieving a record from the middle of the file?
    #2. Explain one advantage that
    a. a sequential file has over an indexed file
    b. a sequential file has over a hash file
    c. an indexed file has over a sequential file
    d. an indexed file has over a hash file
    e. a hash file has over a sequential file
    f. a hash file has over an indexed file
    ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!

                                                                                                                                      Order Now