From 6bf4b90c90f15f4ab60833bddf5b5756d1a6b1f6 Mon Sep 17 00:00:00 2001 From: Elizabeth Alexander Hunt Date: Thu, 2 Jul 2026 11:55:17 -0700 Subject: Init --- Homework/cs5800/Quizzes/1.org | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 Homework/cs5800/Quizzes/1.org (limited to 'Homework/cs5800/Quizzes/1.org') 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. -- cgit v1.3