WEEK 2 ASSIGNMENT - REVIEW PROBLEMS

docx

School

Bellevue University *

*We aren’t endorsed by this school

Course

613

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by AmbassadorHippopotamusMaster963

1 CIS605-T301 Advanced Database Management (2241-1) PROFESSOR: Dr. Nicki Susman WEEK 2 ASSIGNMENT REVIEW PROBLEMS NAME: RAHITHYA KILARU STUDENT ID: 21400585 September 10, 2023

2 Answer the following review questions which are from chapters 1 and 3 of the Petkovic text. 1. What does “data independence” mean and which two forms of data independence exist? Data independence refers to the separation of an application's data from its underlying database structure, allowing for changes to one without affecting the other. There are two key forms of data independence. Logical data independence enables modifications to the conceptual schema without altering the external schema, allowing changes in data organization without impacting applications. On the other hand, physical data independence permits adjustments to the internal schema without affecting the conceptual or external schemas, meaning alterations to data storage and access methods can occur independently of how users or applications interact with the data. These forms of data independence are fundamental in ensuring flexibility and adaptability in database management while minimizing disruptions to user experiences. (Singh, A. J) 2. Let book be a table with two columns: isbn and title. Assuming that isbn is unique and there are no identical titles, answer the following questions: a. Is title a key of the table? No, Title is not a key of the table because a key should uniquely identify each row, and titles are not guaranteed to be unique (two books can have the same title). b. Does isbn functionally depend on title? Yes, Isbn functionally depends on Title as per the assumption that isbn is unique for each title. Functional dependence means that for each title, there is a unique isbn associated with it. c. Is the book table in 3NF? Yes, Whether the table is in 3NF (Third Normal Form) depends on its actual structure, including dependencies and keys. To determine 3NF compliance, you would need to analyze the functional dependencies and ensure that there are no transitive dependencies. It's not possible to determine 3NF status based solely on the information provided. 3. List the steps taken to accomplish the following: Using SSMS create a database called test. Store the database in a file named testdate_a in the directory C:\tmp and allocate 10 MB of space to it. Configure the file in which the database is located to grow in increments of 2MB, not to exceed a total of 20MB. CREATE DATABASE test ON PRIMARY ( NAME = testdata_a , FILENAME = 'C:\tmp\testdata_a.mdf' , SIZE = 10MB , MAXSIZE = 20MB , FILEGROWTH = 2MB );

3 References: Singh, A. J. (2022, March 22). Data Independence in DBMS - Scaler Topics. Retrieved from https://www.scaler.com/topics/data-independence-in-dbms/

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

WEEK 2 ASSIGNMENT - REVIEW PROBLEMS

Related Documents