i would like to understand the concept and want to know the specific details for these questions for better understanding of the case study

Figure 3 Figure 4 QUESTIONS 1. Dean wishes to use Access instead of Excel to store his Plano data. but couldnt the data be stored in an Excel spreadsheet? In other words, does Dean need to use Access in the situation described, or could he just use Access? Why or why not? 2 Is there any justification for Dean's decision to use Access to store the plano database? If so, explain? 3. Examine the columns in Figure 1. a. Name three characteristics - or 3 data attributes (aka elements, items) - of the pianos that are not represented in this table, which you believe would be useful. b. It takes work to collect data. If you were a consultant advising Dean, what criteria should you and he use in 1. Dean wishes to use Access instead of Excel to store his Piano data. but couldn't the data be stored in an Excel spreadsheet? In other words, does Dean need to use Access in the situation described, or could he just use Access? Why or why not? 2. Is there any justification for Dean's decision to use Access to store the plano database? If so, explain? 3. Examine the columns in Figure 1. a. Name three characteristics or 3 data attributes (aka elements, items) of the pianos that are not represented in this table, which you believe would be useful. b. It takes work to collect data. If you were a consultant advising Dean, what criteria should you and he use in deciding whether to include the three additional data that you identified in Question 3.a? c. Is this database a model of an inventory of pianos, or a model of Dean's model of an inventory of pianos? Explain the difference. 4. Suppose, in addition to the data about pianos, Dean wants to store data about the manufacturer such as its address, years of operation, general comment about the manufacturer, etc. Note that Manufacturer is another entity. a. Design a Manufacturer tabje. i.e. tell me the attributes (data elements) that you would include in the table. There is no need to construct the table in any software, just tell me the data elements you need to include. b. Alter the design of the Plano Table (Figure 2) to represent the relationship between Piano and Manufacturer. 1. Dean wishes to use Access instead of Excel to store his Piano data. but couldn't the data be stored in an Excel spreadsheet? In other words, does Dean need to use Access in the situation described, or could he just use Access? Why or why not? 2. Is there any justification for Dean's decision to use Access to store the plano database? If so, explain? 3. Examine the columns in Figure 1. a. Name three characteristics or 3 data attributes (aka elements, items) of the pianos that are not represented in this table, which you believe would be useful. b. It takes work to collect data. If you were a consultant advising Dean, what criteria should you and he use in deciding whether to include the three additional data that you identified in Question 3.a? c. Is this database a model of an inventory of pianos, or a model of Dean's model of an inventory of pianos? Explain the difference. 4. Suppose, in addition to the data about pianos, Dean wants to store data about the manufacturer such as its address, years of operation, general comment about the manufacturer, etc. Note that Manufacturer is another entity. a. Design a Manufacturer tabje. i.e. tell me the attributes (data elements) that you would include in the table. There is no need to construct the table in any software, just tell me the data elements you need to include. b. Alter the design of the Plano Table (Figure 2) to represent the relationship between Piano and Manufacturer. Dean Petrich is a certified piano tuner and technician who has been repairing and restoring pianos since 1973. He also has a career as Deano the Clown, a clown entertainer who performs children's parties in the 5 cattie, WA, metro area. The schedule of his two businesses balance each other. He's busy as a clown in the lat spring summer and fall, and during the rest of the year, he repairs and restores pianos. Over the past 20 years, the demand for pianos has dramatically declined. When Grandma dies, or the kids move out. or some other life change occurs, families have no further use for their piano, and when they find there is no market for it, they call Dean, who pics up that piano for a modes fee. For a number of years, Dean restored those pianos and elther resold or rented them. Since the tuin of the century. however, the decreasing demand for planos has affected him as well, and over time, he's accumulated far too many pianos. Even discarding the worst of them, he has, today. QUESTIONS 1. Dean wishes to use Access instead of Excel to store his Plano data. but couldnt the data be stored in an Excel spreadsheet? In other words, does Dean need to use Access in the situation described, or could he just use Access? Why or why not? 2 Is there any justification for Dean's decision to use Access to store the plano database? If so, explain? 3. Examine the columns in Figure 1. a. Name three characteristics - or 3 data attributes (aka elements, items) - of the pianos that are not represented in this table, which you believe would be useful. b. It takes work to collect data. If you were a consultant advising Dean, what criteria should you and he use in As you can imagine, 100 pianos consume considerable storage. At first, Dean stored then in his workshop, When he ran out of room in his workshop, he built and stored them in a large metal shed. When the shed overflowed with planos, he moved them to plastic tents in a meadow on his property. Unfortunately, the plastic tents are prone to rips and tears, and because Dean lives in the Pacific Northwest, many planos have been ruined by rain, even when he covers them with plastic tarps inside the plastic tents. Two years ago, sinking in his steadily increasing piano inventory. Dean began to offer pianos for free. Not the very best planos - those he hopes to sell - but he offers many quality pianos for free. However, Dean has two problems. First, he doesn't know which pianos are best, and where they are located in the shop, shed, or tents. Second, few people are willing to crawl over the tops of the pianos in the large shed and tents (through refuse of squirsels, rats, and mice) looking for their perfect piano. To resolve this issue, Dean created a Microsoft Access database with only one table: Piano. To fill the database with data, Dean had to first take an inventory of all the pianos and record the data shown in the columns in Figure 1 below: As you know, a one-table database is basically a single theme of data and could just as easily have been stored in Excel, but Dean used Access because he wants to query his data in a variety of ways, l.e. search his data for pianos with specifie characteristics. For example, he might want to know all of the pianos located in a tent that have a sound quality of 4 or higher. He might also want to know which pianos have a sound quality of 1 or less so that he can dispose of them. Further, customers might have particular needs. One might, for example, want a Baldwin spinet (a type of plano); without a database he has no idea whether he has one or where. Because of the dynamic nature of his needs, Dean uses the Access query facility often. Figure 2 shows an example query (with correct form and syntax) that searches for all of the pianos with sound quality of 4 or higher that are located in a tent. Figure 3 shows the results of that query. Dean also suspects that the quality deteriorates faster in the tents than in the shed or the shop. To determine if this is the case, he created the report shown in Figure 4 Dean Petrich is a certified piano tuner and technician who has been repairing and restoring pianos since 1973. He also has a career as Deano the Clown, a clown entertainer who performs children's parties in the 5 cattie, WA, metro area. The schedule of his two businesses balance each other. He's busy as a clown in the lat spring summer and fall, and during the rest of the year, he repairs and restores pianos. Over the past 20 years, the demand for pianos has dramatically declined. When Grandma dies, or the kids move out. or some other life change occurs, families have no further use for their piano, and when they find there is no market for it, they call Dean, who pics up that piano for a modes fee. For a number of years, Dean restored those pianos and elther resold or rented them. Since the tuin of the century. however, the decreasing demand for planos has affected him as well, and over time, he's accumulated far too many pianos. Even discarding the worst of them, he has, today. As you can imagine, 100 pianos consume considerable storage. At first, Dean stored then in his workshop, When he ran out of room in his workshop, he built and stored them in a large metal shed. When the shed overflowed with planos, he moved them to plastic tents in a meadow on his property. Unfortunately, the plastic tents are prone to rips and tears, and because Dean lives in the Pacific Northwest, many planos have been ruined by rain, even when he covers them with plastic tarps inside the plastic tents. Two years ago, sinking in his steadily increasing piano inventory. Dean began to offer pianos for free. Not the very best planos - those he hopes to sell - but he offers many quality pianos for free. However, Dean has two problems. First, he doesn't know which pianos are best, and where they are located in the shop, shed, or tents. Second, few people are willing to crawl over the tops of the pianos in the large shed and tents (through refuse of squirsels, rats, and mice) looking for their perfect piano. To resolve this issue, Dean created a Microsoft Access database with only one table: Piano. To fill the database with data, Dean had to first take an inventory of all the pianos and record the data shown in the columns in Figure 1 below: Figure 3 Figure 4 As you know, a one-table database is basically a single theme of data and could just as easily have been stored in Excel, but Dean used Access because he wants to query his data in a variety of ways, l.e. search his data for pianos with specifie characteristics. For example, he might want to know all of the pianos located in a tent that have a sound quality of 4 or higher. He might also want to know which pianos have a sound quality of 1 or less so that he can dispose of them. Further, customers might have particular needs. One might, for example, want a Baldwin spinet (a type of plano); without a database he has no idea whether he has one or where. Because of the dynamic nature of his needs, Dean uses the Access query facility often. Figure 2 shows an example query (with correct form and syntax) that searches for all of the pianos with sound quality of 4 or higher that are located in a tent. Figure 3 shows the results of that query. Dean also suspects that the quality deteriorates faster in the tents than in the shed or the shop. To determine if this is the case, he created the report shown in Figure 4