String to Integer (atoi) – LeetCode Solutions

LeetCode has a Medium coding Problem in Its’ Algorithm Section in Python “String to Integer (atoi)”. Today We are going to solve this problem. LeetCode Link of the Problem is HERE. Question Implement the myAtoi(string s) function, which converts a string to a 32-bit signed integer (similar to C/C++’s atoi function). The algorithm for myAtoi(string s) is as follows: Read in … Read more

What does ANSI Sparc mean in Databases?

An abstract design standard for DBMS is ANSI SPARC. ANSI SPARC stands for American National Standards Institute, Standards Planning And Requirements Committee started in 1975. Follow this link to know more about it HERE The ANSI SPARC paradigm never adopted as a formal standard. No current DBMS systems are entirely based on it( they usually lack complete physical independence and disallow a direct … Read more

Database System Concepts 7th Edition Solutions -Chapter 2

Database System Concepts is the highly recommended book for the people interested in databases. Free version of this book can be downloaded from HERE. Practice Exercises 2.1 Consider the employee database in below Figure. What are the appropriate primary keys? Primary key is an attribute in a table which can uniquely identify that table. In … Read more

Functional Dependencies Database

In order to design a good database Functional Dependencies in Database is an important concept. In order to ensure the integrity of data and a good performance of a database functional dependencies plays an important role. Definition of Functional Dependency on Wikipedia HERE. Suppose we have a relation in database where there are only two … Read more

How to make Relational model from ER Diagram

In today’s post, we will learn how to make a Relational model from ER Diagram. ER diagram is just a conceptual picture of a database (Definition of ER Diagram HERE). It is one of the important tasks of the programmer to convert that diagram into tables while coding a database. Let’s say we have to … Read more

Conceptual Database Design with ER Model

Conceptual Database Design with ER Model is one of the most important topic in Databases. Whenever a programmer wants to develop a database the ER Model is the basic thing he starts with. ER Model Def. ER Model shows relations between the objects/entities in a database. Wikipedia definition of ER Model HERE. There are three … Read more

Domain Types in SQL – Structured Query Language

A user-defined data types in SQL are Domain Type. You can use the domain instead of a built-in SQL data type. To know the difference between user-defined and built-in data types check our post.  You can use the domain instead of a built-in SQL data type when declaring a column. That column will then be restricted only to use the same domain. Some good definitions of Domain type in SQL are found HERE. … Read more

Database views in SQL – View of Data

Before going into the Database views in SQL, first, let’s see what a Database is?   The database is a collection of interrelated data, for example, the Database of the Hospital. It contains the data related to Patients Drugs, their illness, etc., which are somehow related. A Database must be efficient and sensible; for example, … Read more