In this video we cover the Insert Into SQL statement to insert some data into a table. We ran into some problems already – some phone numbers got stripped off a zero at the front, and it accepted some numbers with incorrect number of digits. All these will be fixed in the next tutorial.
In this lesson we run you through how to create a table in SQL. You learn about the syntax for the create table statement and some data types such as Integer, Varchar and float.
In this lesson we talk about how to map our conceptual schema to relational database tables in the optimal normal form.
In this lesson we talk about some other constraints you can include in your CS diagram.
In this lesson we talk about how to add unique constraints (many to one, one to many, many to many, one to one)
In this tutorial we talk about how to combine surplus entities and state derived entities in our CS diagrams.
Now that you’re okay with drawing CS diagrams with binary relationships, let’s put in some ternary/nested relationships.
In this lesson we start drawing conceptual diagrams – step 2 in information analysis for database design.
In this lesson we talk about what ORM is, and the steps required to use ORM to design a relational database, starting with step 1 – writing elementary sentences.
In this table we talk about the benefits of a relational database as opposed to a flat file database.