What are the pros and cons of having a database language (like SQL) based on an

Question

What are the pros and cons of having a database language (like SQL) based on an industry accepted standard?


Discuss the two functions of Data Administration (DA) and Database Administration (DBA). Summarize the responsibilities of each. Are both these functions essential in an organization which utilizes databases? How can an organization fulfill the needs of either of these functions? (If using the internet to additionally research this question, be careful not to use any job ads or resumes/employment descriptions as these typically are too general to be useful or are not checked for technical accuracy.)

Explanation / Answer

2. The following drawbacks in the file-processing systems are

            2.1 Data –Redundancy

            2.2 Data-Inconsistency

            2.3 Integrity Problems

            2.4 Data isolation

            2.5 Concurrent Access Anomalies

            2.6 Security Implementations

3. To overcome the above drawbacks, SQL comes into existence. Apart from other query languages SQL accepted a few rules of J.F.Cod(Scientist) .Sql languages accepted these 12 rules as an industry standard accepted way.

Some of rules are

3.1 Rule 1: system must qualify as a relational model for designing a complete database system.

3.2 Rule 2: information in the relational model represented in only one way .Each attribute is organized as columns.

3.3 Rule 3:Physical Data Independence

            Changes to the physical level structure is no need to the application level architecture or programming level

3.4 Rule 4.Logical data independent: Logical level changes that mean programming level changes should not affect the physical level architecture.

3.5 Rule 5: integrity Constraint rules: Integrity constraints must be separated and logged in the separate file and available to change without any damage to the table structure or its integrity

4.Creating the database(Collection of tables and they are interrelated by reference) and creation of tables in the SQL is possible by simple interface.

5.Creation of tables ,relations ,primary keys and referential keys or foreign keys can be easily implemented  

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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