ICT Assignment #1 PDF

GRADE: 11: ICT ASSIGNMENT #1: DEAD LINE: 25/05/2024 Part I: Write True if the statement is correct and False if it is incorrect. (justify the Reason why the Statements is Wrong if your Answer is False) 1. A database is a collection of related data. 2. A database approach improves data sharing. 3. ER...

GRADE: 11: ICT ASSIGNMENT #1: DEAD LINE: 25/05/2024 Part I: Write True if the statement is correct and False if it is incorrect. (justify the Reason why the Statements is Wrong if your Answer is False) 1. A database is a collection of related data. 2. A database approach improves data sharing. 3. ERD is a visual representation of data model. 4. There is only one type of relationship between entities in the ER model. 5. Attributes are used to describe the characteristics of an entity. 6. Relational database stores data in one file. 7. A Primary key is an attribute that has duplicate values for differentrecords in a table. 8. Tables are used to store data in Microsoft Access. Part II: Choose the correct answer from the given alternatives. (Review and Re correct your Answer if the Answer is None/”Option F”) 1. _______________________ is used to store a logically related data. A. file B. database E. A and B C. data model D. DBMS F. None 2. The element of ERD that represents real-world things such as people,places, or events about which we want to store data is called: A. attributes B. database E. A and C C. relationship D. entities F. None 3. The properties of entities that are used to differentiate one entity from the other entity is called:____________________________________ A. attributes B. database E. B and C C. relationship D. entity F. None 4. _____________ is considered as a blueprint of a database. A. attributes B. database E. B and C C. data model D. entities F. None 5. In a relational data model, entities are represented as: A. attributes B. relations E. B and D C. data models D. databases F. None 6. ______________________ is a container of database objects in Microsoft Access. A. field B. database E.All except A C. table D. form F. None 7. A field which has a unique value for each record of a table is called: A. foreign key B. attribute E. All except D C. data type D. primary key F. None 8. One of the following is not a valid data type name for a field __________________. A. text or string B. number E.All except C C. entity D. date F. None 9. A Query in Microsoft Access is used to:__________________________________ A. store data for future use B. select records from the underlying table that meet some search criteria C. create a form to facilitate data entry D. All the Above Telegram Group:NAFTECH SPACE &Link: @ Naftech2023 By:Sufiyan A/kadir, 20/03/2024 Gc  E. All except C F. None 10. In order to retrieve data from two or more tables through query, we mustestablish a _____________________________ between tables A. field B. primary key E. All except A C. relationship D. criteria F. None Part III: Write short answers to the following questions (shortly &Clearly) 1. What is a database? Give examples. 2. What are the basic elements of ERD? 3. What is a relational data model? Give examples. 4. What is a one-to-many relationship? Give examples. 5. What is the use of table object in Microsoft Access? Give examples. 6. What is the use of query in Microsoft Access? Give examples. Part IV: Discussion questions Answer the following case study questions 1. XY manufacturing (Electronics) company produces different types of products. The products are described by: product ID, product name, quantity, price and Total Price. The products are sold to different customers. The company also keeps track of its customers’ information as customer ID, customer name, Father Name, customer address and Order type. The customer makes orders to buy products from the company at different times. It is also necessary to keep order information, which includes order ID, product ID, customer ID, order quantity, and order date. Additional Information Customer Table Customer ID (PK) CustomerName Father Name Customer Address Order type Cr0001 Shamsu Ali Worabe City Cash Cr0002 Geda Wayessa Shagger City Cash Cr0003 Tilahun Getachaw Gonder City Credit Cr0004 Muhammed Ali Walkite City Credit Cr0005 Muhammed Ali Walkite City Credit Cr0006 Shalom Gidey Mekele City Credit Cr0007 Abdella Adem Jijiga City Cash Cr0008 Hawi Abdella Adem City Cash Cr0009 Jarra Kadir Robe City Credit Cr0010 Bati Gobena Finfinne City Cash Telegram Group:NAFTECH SPACE &Link: @ Naftech2023 By:Sufiyan A/kadir, 20/03/2024 Gc Order Table Order ID (PK) ProductID (FK) CustomerID(FK) Order Date Or0001 Pr0010 Cr0006 20/1/2023 Or0002 Pr0001 Cr0004 20/1/2022 Or0003 Pr0001 Cr0010 20/1/2024 Or0004 Pr0004 Cr0004 22/1/2022 Or0005 Pr0001 Cr0001 20/1/2022 Or0006 Pr0006 Cr0007 30/1/2022 Or0007 Pr0008 Cr0005 20/4/2022 Or0008 Pr0001 Cr0002 20/1/2022 Or0009 Pr0002 Cr0004 20/8/2022 Or0010 Pr0001 Cr0001 20/4/2022 Product Table Product ID (PK) Product Name Quantity Price Total Price Pr0001 Smartphone 20 $600 $12000 Pr0002 Laptop 40 $800 $320000 Pr0003 Tablet 60 $400 $24000 Pr0004 Digital Camera 100 $500 $50000 Pr0005 Bluetooth Speaker 80 $100 $8000 Pr0006 Wireless Router 100 $100 $10000 Pr0007 Home Theater System 25 $500 $12500 Pr0008 Virtual Reality Headset 40 $400 $4000 Pr0009 Desktop Computer 100 $100 $10000 Pr0010 Smart TV (55-inch) 2000 $600 $120000 Required: 1. list & Identify all the entities 2. list & Identify all the attributes 3. Create the relationships 4. construct an ERD for the data model 5. list & Identify all the entities 6. list & Identify all data types for each attributes of Customer Table 7. list & Identify all data types for each attributes of Product Table 8. list & Identify all data types for each attributes of Order Table 9. How many Number/s of Record(s)/Full in Customer Table 10.How many Number/s of Record(s) in Product Table 11.How many Number/s of Record(s) in Order Table 12.What are the Cardinalities of this Database? 13.What is the Possible Name of this Database? 14.Display All data of Customer Records by Using Query before R/ship 15.Is there any deference between Q#14 Result and Original Records? 16.Display All data of Customer Records by Using Query After R/ship 17.Is there any deference between Q#16 Result and Original Records? Why? 18.Display All data of Product Records by Using Query before R/ship 19.Is there any deference between Q#18 Result and Original Records? Why? 20.Display All data of Customer Records by Using Query After R/ship Telegram Group:NAFTECH SPACE &Link: @ Naftech2023 By:Sufiyan A/kadir, 20/03/2024 Gc 21.Is there any deference between Q#20 Result and Original Records? Why? 22.In Which table the Primary Key is the most important? Why? 23.In Which Records the Primary Key is the most important? Why? 24.Create Queries and Display Name and Address of Customer his/her Father’s Name is Ali 25.How many Number of Records Displayed from the Result of Q#24 above? Why? 26.Create Queries and Display Father’s Name and Address of Customer his/her Name is Muhammad 27.How many Number of Records Displayed from the Result of Q#26 above? Why? 28.Create Queries and Display ID, Name and Father’s Name of Customer his/her city is Walkite 29.Select and Display data from fields of Customer table except from Walkite City 30.Select and Display Customer ID,Name,Address from Customer table, Order ID, Order date from Order Table and Product ID, Product Name, Quantity and Total Price Respectively. 31.Select and Display all fields from All Tables. 32.How many Fields are displayed from the Results of Q#30 above? 33.List All the Name of Customer Addresses their start by Letter”W” from Q#30 above? 34.What is the Name, Quantity and Total Price of ordered Product? From Q#30 above? 35.List All the name Products ordered by Customer their name are “Muhammad” FromQ#30 36.What is the Common Similarity of Customer their name is “Muhammad”? FromQ#30 37.Which is Frequently Ordered Product? From Q#30 above? 38.By which Order Maximum Total price performed? From Q#30 above? 39.By which Order Minimum Total price performed? From Q#30 above? 40.Who is the Resident of Shagger City? From Q#30 above? 41.By whom Smart TV (55-inch) is ordered? From Q#30 above? 42.What is the most frequently ordered Product? How many times? Who make the last order? What is the last order date? From Q#30 above? 43.Create Queries and Display Customer name from Customer table, order Id and order date from order table and product name and Unit price from product table and save as Query 2. 44.Display customer name, Order Id, Order date and Unit price of Product its name contains letter “y” and how many products are there? From Q#43above? Please Use the short methods. 45.Display customer name, Order Id, Order date and Unit price of Product its name contains letter “V” and how many products are there? From Q#43above? Please Use the short methods 46.Display customer name, Order Id, Order date and product name its Unit price equals to “$600” and which product was frequently ordered? From Q#43above? Please Use the short cut 47.Display customer name, Order Id, Order date and product name its Unit price between “$100” and“$500” and which product was ordered by Abdella? When? And at what order? From Q#43above? Please Use the short methods 48.Design and Create Form from table Q#43 above 49.Design and Create Report from table Q#43 above 50.Print the Report of Q#49 above Telegram Group:NAFTECH SPACE &Link: @ Naftech2023 By:Sufiyan A/kadir, 20/03/2024 Gc