Page 10 of 11

What Is SQL Server Management Studio?

SQL Server Management Studio (SSMS) is the main console of SQL Server.

Screenshot of SQL Server Management Studio (SSMS) in SQL Server 2014.

SQL Server Management Studio (SSMS) is the main console of SQL Server.

SQL Server Management Studio allows you to create and manage your databases as well as administer your SQL Server configuration.

Continue reading

What is a Foreign Key?

A foreign key is a field that is linked to another table‘s primary key field in a relationship between two tables.

In relational database management systems, a relationship defines a relationship between two or more tables. That is, the data in one table is related to the data in the other. One table contains the primary key and the other table contains the foreign key.

When we establish a relationship between the tables, we link the foreign key with the primary key. From that point on, any value in the foreign key field should match a value from the primary key field in the other table.

Continue reading

What is a Primary Key?

A primary key is a column that has been configured as the unique identifier field for the table.

Any value stored in a primary key field is unique to that record. No other record in that column contains that value. The value is a unique identifier.

Continue reading

What is a Relationship?

In relational database design, a relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables.

Relationships are a key element in relational database design.

Here’s an example:

Diagram of one-to-many relationship

Example of one-to-many relationship.

In the above example, the City table has a relationship with the Customer table. Each customer is assigned a city. This is done by using a CityId field in the Customer table that matches a CityId in the City table.

While it’s certainly possible to store the full city name in the Customer table, it’s better to have a separate table that stores the city details. You can easily use a query to look up the CityName by using the CityId that’s stored for that customer.

Continue reading

How to Create a Macro in Access

To create a macro in Microsoft Access 2013 or 2016:

  1. Click Macro from the CREATE tab
  2. Add actions by selecting an action from the combo box
  3. Customise the actions if required
  4. Repeat steps 2 and 3 for each action you want to add
  5. Save the macro

Continue reading

What is an RDBMS?

RDBMS stands for Relational Database Management System.

An RDBMS is a particular type of DBMS that uses a relational model for its databases. An RDBMS therefore enables you to create relational databases.

Relational database management systems have become the most popular type of database system. Most major database management systems are relational. Popular examples include Microsoft Access, SQL Server, Oracle DatabaseMySQL, FileMaker, PostgreSQL, and more below.

Continue reading

The 3 Types of Relationships in Database Design

There are 3 types of relationships in relational database design. They are:

  • One-to-One
  • One-to-Many (or Many-to-One)
  • Many-to-Many

Continue reading

How to Create a Database in MySQL Workbench using the GUI

To create a database in the MySQL Workbench GUI:

  1. Click the “new schema” button on the MySQL Workbench toolbar
  2. Enter a schema name (database name) and its default collation and click Apply
  3. Review the SQL statement and click Apply

The database will now be created, and a message will display advising that the script was successful.

Continue reading

How to Create a Table in MySQL Workbench using the GUI

To create a table in the MySQL Workbench GUI:

  1. Under the appropriate database in the left navigation pane, right-click Tables and select Create Table...
  2. Enter the table name, add all column names, their data type, constraints, default values, and any other details as required, then click Apply
  3. Review the SQL statement that will be run against the database and click Apply

The table will now be created, and a message will display advising that the script was successful.

Continue reading

How to Create a Table in SQL Server

To create a table in SQL Server using the GUI:

  1. Ensuring that the right database is expanded in Object Explorer, right click on the Tables icon and select Table... from the contextual menu
  2. A new table will open in Design view. Add the columns, their data types, and column properties.
  3. Save the table (either from the File menu, or by right-clicking on the table tab and selecting Save Table1)

The table will appear in the Object Explorer under the Tables icon for the applicable database.

Continue reading

« Older posts Newer posts »

© 2017 Database.Guide

Theme by Anders NorenUp ↑