ASSIGNMENT
QUESTION 1 Discuss What are some database functions that a spreadsheet cannot perform.
QUESTION 2 :- Read chapter 1 of your textbook and review IGU online resources and reputable articles / journals and describe Problems with File System Data Processing. Provide examples if applicable.
QUESTION 3:- What is a relationship, and what three types of relationships exist? Provide a real world/application example for each of the three types of relationships.
QUESTION 4 :- What are business rules, what is their source? and why are they crucial in defining entities, relationships and attributes? Provide a few examples of business rules for a business that you are familiar with for example a university, a banking system or any business of your choice.
QUESTION 5:- Read chapters 2 and 3 textbook and review reputable IGU online library resources and journals and discuss: Advantages and Disadvantages of Relational Model.
QUESTION 6 :- Read chapter 3 and reputable journals/articles and IGU online library resources and describe the following relational operators: Union, Project, Intersect and Join. Provide a real-world application example for each of these operators.
QUESTION 7:- Read chapter 3 and reputable journals/articles and IGU online library resources and describe the following relational operators: Union, Project, Intersect and Join. Provide a real-world application example for each of these operators.
QUESTION 8:- What does it mean to say that a database displays both entity integrity and referential integrity? And why entity integrity and referential integrity important in a database? Provide an application example to support your discussion.
