blob: c4909004cdea5892052261164d65365cd279ed28 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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.
|
