What are the benefits of storing data using databases? Discuss three levels of database system architecture in detail. These days, almost every company stores their data in a database. An organised set of data that can be quickly and readily accessed, controlled, and updated is called a database.Lets see the benefits of storing data using … Read more
It is important for people who work with tables to understand the difference between rows and columns. This is true whether they are using a database management system like Oracle or spreadsheet program like Microsoft Excel. Many times, people use these terms for the same thing, which can be confusing because they mean different things. … Read more
Advantages and Disadvantages of Database Management System (DBMS) What is a database? A collection of data that is interrelated and can be used to retrieve, insert, and modify data efficiently. It can also be used to organise data in a database in the form of a schema, table, views, reports, and so on. A database … Read more
What is Database and Characteristics of data in Database? In this article we will study about What is Database and Characteristics of data in Database? In simple terms, a database is a well-organised library that holds critical information for an organisation. It acts as a data container, similar to a repository for a collection of data … Read more
Database Design and Development Topic: Overview of Normalisation concepts MCQs and True/False i. The advantages of normalisation include ________. the elimination of modification anomalies the elimination of duplicated data more complex SQL for multitable subqueries and joins simpler SQL queries ii. The defining characteristic of BCNF is that a table is in BCNF if ________. … Read more
Database Design and Development Topic: Structured Query Language (SQL) – Part 1 MCQs i. SQL stands for Standard Query Language. True/False ii. The SQL keyword LIKE is used in SQL expressions to select partial string values. True/ False iii. In an SQL query, which SQL keyword actually begins the query? EXISTS FROM SELECT WHERE iv. … Read more
What do you understand by a strong entity and a weak entity? Provide example. A strong entity is complete by itself and is not dependent on any other entity type. EXAMPLE customer(customerID, name,surname) A weak entity is dependent on a strong entity to ensure its existence. Adress(addressid, adressName, customerid) i. What do you mean by … Read more