Best Practices: Does Professional Database exists?
Dec18

Best Practices: Does Professional Database exists?

Welcome to CodeSpread! What is Database? Database is a structured set of data, which facilitates storage,search and retrieval. Databases revolves around tables and relationships between them. Imagine you have a truck load full of apples, each marked with a number. If these apples are not arranged as per their numbers then it would be difficult to find the requested apple having a particular number in less time. Silly example? but silly works. What is Database Design? We know that Database is a structured set of data, but what is this structure? This is the question we try to answer by designing our database. Designing a database is a mapping between user’s requirements and logical implementation of these requirements.For example: If user[employee] wants his name and his manager’s name to be stored in the database, then the designer will think of only ONE table having column ManagerID referring to EmployeeID. EmployeeID | EmployeeName | ManagerID If incorrect structure is imagined , then we might see two tables, one for employee and other for manager. It is an important decision as once implemented, it would be difficult to go back and change the design. A well-designed database is what we should aim for. Is there any guideline to achieve professional database? Are we looking to reinvent the wheel here,? My answer would be ‘No’. I believe in accepting the fact that old methodologies and best practices are good enough to achieve excellence. Same applies to the process ‘development of professional database’. As I said in my  last article, that quality is an iterative process to achieve a degree of optimization. When we think of DB design, we try to use all the best practices and if we found out that it is still not the best design , we follow the same iterative process to achieve better performance of our DB. There are few guidelines which might be useful for one set of DB and discarded by others, as these are outcomes of experience and not a rule-set. That means, No debates, Please! What are the pitfalls? Everything begins from requirement gathering so if we have not done proper analysis of requirements then there is a high chance that our database design will get affected. Partial clarity on business requirements. Did not Identify the nature of application as It might be CRUD based or Analytics based. Did not Identify the duplicate content before development starts. There might be disconnected data but always accounts for this data as it might create redundancy. Incorrect level of Normalization might create either an over normalized database or under normalized database. Ugly Naming conventions which impacts...

Read More

How to create database with SQL express bundled with Visual Studio?

Yes, Visual studio comes bundled with a copy of SQL express edition which gets installed during visual studio installation. These steps are required to create database with SQL express bundled with Visual Studio. So guys, I request you all to please perform these steps while reading this article. View Server Explorer Add a Server Server Details Create Database Database details Choose Add Connection Add Connection Connection Properties Click on at least one image to start the slideshow Refer Slide 1,To view the SQL express,Click on ‘View’ -> ‘Server Explorer’. Refer Slide 2, Right Click on ‘Servers’ and select ‘Add a Server’. Refer Slide 3, Write Server Name in the Dialog, In this case, you have to write your machine name. Refer Slide 4,To create a database,Right Click on Data Connections and select “Create SQL server database”. Refer Slide 5, In the dialog box, select  server name from the list, select the authentication you want to use and provide a new database name. Refer Slide 6, To create a connection,Right Click on Data Connections and select “Add Connection”. Refer Slide 7,In “Choose Data Source” dialog box, select “Microsoft SQL Server”, data provider will get filled simultaneously.Click continue. Refer Slide 8, Fill Connection properties in the dialog box, select server name from the list. Once server is selected, “Connect to database” section gets activated,  select database and click “Test Connection”. Comments...

Read More