InitHEADmain

2 files changed, 86 insertions, 0 deletions

diff --git a/Homework/cs5800/Quizzes/1.org b/Homework/cs5800/Quizzes/1.org
new file mode 100644
index 0000000..c490900
--- /dev/null
+++ b/Homework/cs5800/Quizzes/1.org
@@ -0,0 +1,24 @@
+1. True +
+2. False x
+3. False
+4. True _
+5. True X
+6. False _
+7. True _
+8. False _
+9. True +
+10. True _
+
+    Web Server used to encrypt data before sending to client
+    Database schema - includes description of the database structure
+    Internal schema - describe phuysical storage structures and access paths
+    An ER model can be transformed into a relational model
+    A databayse system is composed of the DMBS + database
+    Atomic transactions assure that the database is in a consistent state
+
+In this case a three-tier client/intermediate/server architecture would be the most well-suited for the job.
+On the client side there would be a Web Interfact written in something like HTML, CSS, and JS. The user would interact with this client, which would send requests to an intermediate web server through an API which would handle the business logic.
+For example this server might retrieve the general geolocation from the IP address of the customer's request from an external service, then make a query to the actual DBMS for hotels within a certain radius, and respond to the client with hotel objects from the database, potentially adding another step filtering the response with some more business logic.
+
+1) A procedural DML can be referred to as only the data sublanguage, and is required to be embedded in a general-purpose programming language and typically retrieves individual records from the database. A nonprocedrual or high level language, such as SQL, can also be referred to as a query language. It is also more declarative in that data is accessed via declaring *which* to access rather than *how* and can process multiple retrievals from the database.
+2) The database manager, or execution engine, is the only element in a DBMS that has access to change the DB's schema and instance. On the other hand, the run time processor - used in determining the sequence of associated steps of user commands and privileged DBA commands - has access to the schema and instance, but only through what is provided by this execution engine.
diff --git a/Homework/cs5800/Quizzes/2.org b/Homework/cs5800/Quizzes/2.org
new file mode 100644
index 0000000..a24d754
--- /dev/null
+++ b/Homework/cs5800/Quizzes/2.org
@@ -0,0 +1,62 @@
+1. False
+2. False
+3. True
+4. ?
+5. True
+6. True
+7. ?
+8. True
+9. True
+10. True
+
+    
+1. There are three foreign keys: "serial_no" is a foreign key relating "option" to a "car", "salesperson_id" is a foreign key relating "sale" to a "salesperson", and "serial_no" is a foreign key relating "sale" to a "car".
+
+2.
+
+CAR:
+
+(1, "Impala", "Chevrolet", 2000)
+
+(2, "Odyssey", "Honda", 4000)
+
+(3, "S", "Tesla", 100000)
+
+OPTION:
+
+(1, "bluetooth", 20)
+
+(2, "automatic doors", 400)
+
+(2, "leather seats", 1000)
+
+(3, "autopilot", 2000)
+
+SALESPERSON:
+
+(1, "Logan", "112-358-1321")
+
+(2, "Bob", "271-828-1828")
+
+(3, "Alice", "314-159-2654")
+
+SALE:
+
+(1, 1, "2022-10-02 15:47", 2020)
+
+(2, 3, "2022-03-04 12:34", 100000)
+
+3.
+
+SALE that would violate referential integrity because there is no salesperson with a salesperson_id of 10:
+
+(10, 2, "2022-01-01 00:01", 5000)
+
+SALE that would not violate referential integrity because there is a salesperson with a salesperson_id of 2 that did not sell car with serial number of 2:
+
+(2, 2, "2022-12-31 11:59", 5000)
+
+Weak entity type => An entity that cannot be uniquely identified by its attributes
+identifying relationship type => the relationship that relates the weak entity type to the owner
+owner entity type => is an entity type that relates to a weak entity type and identifies it
+partial key => an attribute that distinguishes instances of a weak entity type relative to a strong entity