https://vertabelo.com/blog/how-to-remember-database-normal-forms/ Normal Forms: A Recap The key, the whole key, and nothing but the key, so help me Codd. The key stands for 1NF: all tables must have a (primary) key because all records in the table must be unique.The whole key stands for 2NF: no functional dependencies on part of the key are allowed.Nothing but the key (attribute) stands for 3NF: no functional dependencies between non-key attributes are allowed.Nothing but the key stands for BCNF: only functional dependencies out of candidate keys are allowed. “2NF/3NF: Every non-key attribute isdependent on the key, the whole key, and nothing but the key—so help me Codd.” Example: The db from… Database diagram…

Database diagram used for some learning (Bikestore) The rest is here: https://github.com/spawnmarvel/t-sql https://github.com/spawnmarvel/t-sql In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used. Run just portions of the query, mark the section and execute: docs microsoft sql server https://docs.microsoft.com/nb-no/sql/?view=sql-server-ver15 CASE expression https://github.com/spawnmarvel/t-sql/blob/master/module3.sql Joins https://github.com/spawnmarvel/t-sql/blob/master/module4_multiple_tables.sql INNER JOIN (Get all that matches on both tables) SELF JOIN, related to get the manger Change schema: Right-click on the specific table name and choose Design optionRight-click on the window->propertiesAnd we are there (after the change, save solution and disconnect-connect. Connected again: View all functions…

Version used here SQL Server Management Studio 15.0.18206.04 The following illustrates the BikeStores database diagram: 5 Load Sample Database After that data is loaded, you can make your own diagram, navigate like this: Go to Sql Server Management Studio >Object Explorer >Databases >Choose and expand your Database.Under your database right click on “Database Diagrams” and select “New Database Diagram”.It will a open a new window. Choose tables to include in ER-Diagram (to select multiple tables press “ctrl” or “shift” button and select tables).Click add.Wait for it to complete. Done!! BikeStores Sample Database – create objects.sql – this file is for creating database objects including schemas and tables.BikeStores Sample Database –…

Download MS SQL Server 2016 Express: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool from the install, or download it from MS. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud. SSMS is free! Connect: .\SQLEXPRESS or the below Create a autoincrement,…

‘Sanitization’ is the removal of malicious data from user input, such as form submissions or maybe more simply… The cleaning of user input to avoid code-conflicts (duplicate ids for instance), security issues (xss codes etc), or other issues that might arise from non-standardized input & human error/deviance. Define Business Requirements before Beginning Write very specific requirements and confirm them with stakeholders. The performance of the production database is too critical to have unclear or ambiguous requirements. Make sure the requirements are as specific as possible, and confirm the requirements with all stakeholders before running the query. Define SELECT Fields instead of SELECT * Inefficient: SELECT *FROM Customers Efficient: SELECT FirstName,…