Join Adam Wilbert for an in-depth discussion in this video Creating the tables in SQL Server, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…Now we're ready to start implementing our…database design in SQL Server Management Studio.…First, let's explore the data model I…developed for the Two Trees Olive Oil Company.…I've decided that we need four tables in…order to store information about our customers, their…invoices, the line items that appear on those…invoices, and the products that are being ordered.…Notice that I've settled on a camel case naming convention that doesn't…use any spaces in either the field names or the table names.…Now let's take a look at the relationship between these tables.…We'll see that I've established…three one-to-many relationships between these tables.…
Okay, let's go ahead and start implementing this…data model inside of SQL Server Management Studio.…First, I'm going to go ahead and connect to the SQL Server.…I'm just going to use Windows authentication and say Connect.…And that'll start it up.…Now, come over here to the left-hand side in…the Object Explorer and I'll expand the database folder.…Then I'm going to right-click on that and say create a new database.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.