To complete this Assignment: Submit a 2-3 paragraph paper in which you address t

Question

To complete this Assignment: Submit a 2-3 paragraph paper in which you address the following: Identify the user (end-user, programmer of application software, database administrator, and designer of database management system software) who would be most concerned with the following scenarios: How data could be most efficiently stored on a disk. If there is a vacancy on Flight 243. How a relation could be stored as a sequential file. How many times a user should be allowed to mistype a password before a conversation is terminated. How the PROJECT operation (of the relational model) can be implemented? Explain why each identified user is most applicable to each scenario and how you came to your conclusions. Fully state and justify any choices, assumptions or claims that you make using the suggested Learning Resources for this Week and/or your own research.

Explanation / Answer

1. How data could be most efficiently stored on a disk.--> Database Administrator
2. If there is a vacancy on Flight 243.--> End User
3. How a relation could be stored as a sequential file.-->Application Programmer
4. How many times a user should be allowed to mistype a password before a conversation is terminated.--> Application Programmer.
5. How the PROJECT operation (of the relational model) can be implemented.--> Designer of DBMS.
Conclusions.
1. Database Administator is the person who is responsible for administrating the database. They are responsible to look after its usage and by whom it should be used. They create access profiles for users and apply limitations to maintain isolation and force security. So DBA is concerned with the DATA effectivness.
2. End User only concerns with the final data what he is needed, The 2nd Scenario clearly defines the what an End user is concerned with.
3. Application programmers write programs to handle a specific job, such as a program to track inventory within an organization. Here sequential Data store records in sequential order, based on the value of the search key of each record. An application programmer is the only user who concerns with type of role.
4. Application programmers write programs to handle a specific job, such as a program to track inventory within an organization. Here sequential Data store records in sequential order, based on the value of the search key of each record. Here the specific job is to apply an constrain regarding the password mismatch. An application programmer is the only user who concerns with type of role.
5. DBMS Designer role defines the tables, indexes, views, constraints, triggers, stored procedures, tablespaces or storage parameters, and other database-specific constructs needed to store, retrieve, and delete persistent objects, which in short can be called as PROJECT operation.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.