BIS 245 WEEK 3 ILAB VISIO ERD EXAM SCRIPT 2026 COMPLETE QUESTIONS SOLUTIONS GRADED A+

BIS 245 WEEK 3 ILAB VISIO ERD EXAM SCRIPT
2026 COMPLETE QUESTIONS SOLUTIONS
GRADED A+

◉ My Educator. Answer: Application/frontend to access data


◉ DBMS. Answer: database management system


ex: SQL


"town where many databases (houses) can be built"


◉ data. Answer: "people that occupy a house within a town"


◉ schema. Answer: -defines the structure and organization of the
database and the information that it contains


◉ attributes. Answer: pieces of information about a person/thing
that are relevant for a particular database


◉ ERD. Answer: =entities + relationship

,◉ entities. Answer: -collect data about attributes
-primary keys
-nouns


◉ relationships. Answer: -foreign keys


-verbs


-made by matching primary keys to foreign keys


◉ query. Answer: to ask, request and get an answer in SQL


◉ select statement. Answer: Select
From
Where
Group By
Having
Order By


◉ order of processing. Answer: Select = 5
From = 1
Where = 2

, Group By = 3
Having = 4
Order by = 6


◉ Identifiers and Attributes. Answer: What are two of the most
important pieces of information stored in a database about an
entity?


◉ SQL. Answer: The ______________ is the industry standard language
used to manipulate data in a relational database


◉ information technology. Answer: hardware, software and media
used to store, organize, retrieve and communicate information


◉ variable characters. Answer: can store anything up to 30
characters long


◉ WHERE clause. Answer: -results are either true of false
-if true, results will be included in result set


◉ distinct. Answer: To eliminate duplicate values, put into the
SELECT clause the keyword...