DATA BASE MANAGEMENT SYSTEMS Name: Institutional Affiliation: Essentially a database is an assortment of related facts and figures; data useful for communication or processing of information. Therefore a database management system or collection of programs of data storage made up of related information that is aimed at ease of retrieval manipulation and production. DBMS are characterized by isolation and grouping of data based on similarity and relevancy. They also adhere to rules of normalization to reduce redundancy use related tables consistent methods and techniques a more realistic design based on the purpose a query language ACID properties to imply Atomicity consistency isolation and durability. It also comprises multi and concurrent user interfaces multiple views and security for diverse users. Ramakrishnan R. & Gehrke J. (2000) Users are the different parties who interact with DBMS: administrators; those who monitor its usage designers; these come up with the set of entities difference with the sparse key in its storage on the disc containing the actual database CONSTRAINTS These are a set of conditions that must hold for any relation to be binding; relational integrity constraints. Key or domain constraints require minimal subsets or attributes and limit duplication while domain constraints are predominated by specific values in reality and are bound to a specific range of values. Example 1 For instance to select from the relation “Undergraduate students” born in the year 2000 The code for this view can be ⱺ Yr-bir=2000(student) Example 2: Database Viewing specific information about students on a database CREATE: the view name SELECT: the columns FROM: the name of the table WHERE: the condition References Beynon-Davies P. (2004). Database systems (p. 61). Palgrave Macmillan. DBMS Codd's 12 Rules. (2018). www.tutorialspoint.com. Retrieved 9 March 2018 from https://www.tutorialspoint.com/dbms/dbms_codds_rules.htmRamakrishnan R. & Gehrke J. (2000). Database management systems. McGraw Hill. [...]
The essay for this lesson is required to be 1,000-1,500-words and clearly demonstrate your understanding of the prompt. Essays should be 5 or more paragraphs with a clear introduction, thesis statement and conclusion, written in APA format (APAstyle.org). Provide two real-life examples of a DBMS. Write a multi-paragraph response.