Reference no: EM133428419
Question 1 Discuss What are some database functions that a spreadsheet cannot perform.
Question 2 :- Please 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:- Please 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 :- Please read chapter 3 and reputable journals/articles and IGU online library resources and describe the following relational operators: Union, Project, Intersect and Join. Please provide a real-world application example for each of these operators.
Question 7:- Please read chapter 3 and reputable journals/articles and IGU online library resources and describe the following relational operators: Union, Project, Intersect and Join. Please 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.