Explore
For Enterprise
Join for Free
Log In

artes y humanidades
Negocios
Ciencias de la Computación
Ciencia de Datos
Tecnología de información
salud
Matemáticas y Lógica
Desarrollo Personal
Ciencias Físicas e Ingeniería
Ciencias sociales
Aprendizaje de un idioma
Títulos y certificados

Explorar todo lo que Coursera tiene para ofrecer

Explorar
Buscar
For Enterprise
Inicia Sesión
Únete de forma gratuita

Video #3 - Database Schema I

Loading...

Web Application Development: Basic Concepts

Universidad de Nuevo México

4.6 (130 calificaciones) | 31K estudiantes inscritos

This is the first course in a Coursera Specialization track involving Web Application Architectures. This course will give you the basic background, terminology and fundamental concepts that you need to understand in order to build modern full stack web applications. A full stack web developer is familiar with each "layer" of the software technologies involved in a web application, including data modeling and database technologies, the web server environment and middleware components, network protocols, the user interface and basic visual design and user interaction concepts. In this course we will learn by doing. We will start by learning the major components of web application architectures, along with the fundamental design patterns and philosophies that are used to organize them. You will build and continually refine a fully functional full-stack web application as we progress through the modules in this course. Along the way you will be exposed to agile software development practices, numerous tools that software engineers are expected to know how to use, and a modern web application development framework. This course is also available in Spanish. To join the Spanish version, visit this page: https://www.coursera.org/learn/apliweb.

Destrezas que aprenderás

Ruby On Rails, Web Application, Web

Revisiones

4.6 (130 calificaciones)

5 stars
92 ratings
4 stars
28 ratings
3 stars
4 ratings
2 stars
2 ratings
1 star
4 ratings

BI

Nov 15, 2016

Very concise and well structured lecture. Also easy to grasp for beginner and pro Rails developer

CK

Oct 02, 2018

Lot's of great information on how web applications work and best practices. Well worth the time!

De la lección

Module #3 - Managing Data

A successful web application provides information t o users that is (1) useful, and also (2) easy to access and understand. This information is often collected from users, as well as from other information sources, and must be stored in a manner that allows it to be manipulated by the web application. The typical app roach is to store this data in a relational database. In this module you will learn some basic concepts associated with modeling the data in a web application, including h ow to specify the relationships between various data entities. We will also investigate ho w to hook a web application up to a back- end data store, along with good design techniques t hat will make it easier to use the data in your web applications by maintaining consistency th roughout the entire web stack.

Relational Databases in Web Apps - An Overview0:20

Video #1 - Data Management in Web Apps3:14

Video #2 - Relational Databases: Basic Concepts3:59

Video #3 - Database Schema I4:58

Video #4 - Database Schema II2:35

Impartido por:

Greg Heileman
Professor and Associate Provost
Manel Martínez-Ramón
Professor

[MUSIC]

We've already seen how rails creates databases using the schema.rb file.

The schema file is created as a result of running the scaffold generators and

then rake db:migrate.

When you're trying to design the appropriate structure for

the data in your web application, you'll sometimes find it useful to work at

the schema level, so let's talk about that in a little bit more detail now.

What exactly is a schema?

Well, it's the formal structure and organization of a database,

it's how you document that.

Now, a database can be instantiated from a schema.

In this case, the database itself is what holds the data, the actual records.

An the schema is just a design, it doesn't store any records.

A very common way of representing a schema is to use an entity relationship diagram.

Here's the database structure we ended up with as a result of the normalization

we performed previously.

Let me show you how to capture this structure more formally as an entity

relationship diagram.

First, draw the people entity, and list all of its attributes.

And then, draw the phone's entity, and list all of its attributes.

Next, we're going to use what's known as the crow's foot notation between

the people and phone entities to represent the one to many relationship.

Each of these tables has their own primary key.

Now, the foreign key association always shows up on the side with the crow's foot.

So, this notation indicates that on the phones side there can be zero, one, or

many phones associated with a person.

But on the people side, a given phone can belong to one and only one person.

That's why there is only a single line coming out of the people entity.

There are many tools available for creating entity relationship diagrams.

Which store entity relationship models.

Entity relationship diagrams are called ERDs for short.

Many of these tools are free and other good ones are fairly inexpensive.

Some of these tools can be used to construct a Schema from an ERD.

To generate an ERD from a database or

to compare the Schema associated with two database.

This last one can be useful to determine if the Schema Associated with

an application matches the one in a design document.

That is, have the development activities led to a new schema that should be

documented in the evolving design documents?

Here's a very short list of some of the tools available for creating ERDs.

I'll show you how to use MySQL Workbench.

It's Free and easy to use.

Go to MySQL.com and download MySQL workbench.

Install the version that works for your operating system.

Then, go to the file menu and select new model.

You'll see something like this.

We're going to add a new diagram, so double click on this here, and

here we have a layout for constructing ERD's.

Here's how you create an entity with this symbol, if I click on it here.

Let's go ahead and double click on it, and then I can create the people entity.

It's going to have a primary key, so I'm going to select this, and

I'm going to double click here and just call this ID.

I can add the other attributes so we had a first name.

And we're going to say that we don't want to let this be null,

you have to store first name.

It's not a primary key so I left that unchecked.

I can put the last name, and you don't really have to worry much that the data

type that it's choosing is varchar, but don't worry about that for

right now, we're just trying to document the structure.

And then we're going to have an address which is going to be also a string.

And so here's one table.

If we want to put another one on for Phones then

double click on this and we can edit this table so this will be our phones table.

And again it's going to have an ID, a primary key.

And you can fill the rest of this in as well, it's going to have a phone

number I have been just calling that phone and that could be stored as a character.

And then to create the relationship that many to

one relation between the two select this close foot.

And you put it on the many side and then click on the one side and

it creates a relationship between the two and

notice that it added the foreign key into the phones entity.

It took care of the Of that when I added the minute to one relationship.

So here we have a entity relationship diagram for the people phones model.

Explora nuestro catálogo

Inscríbete de manera gratuita y obtén recomendaciones personalizadas, actualizaciones y ofertas.

Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.

© 2019 Coursera Inc. Todos los derechos reservados.

Descargar en la App Store

Consíguelo en Google Play

Coursera
Acerca de
Liderazgo
Empleo
Catálogo
Certificados
Certificados MasterTrack™
Grados
For Enterprise
For Government

Comunidad
Learners
Partners
Developers
Beta Testers
Translators

Conectar
Blog
Facebook
LinkedIn
Twitter
Instagram
Youtube
Blog de Tecnología

Más
Términos
Privacidad
Ayuda
Accesibilidad
Prensa
Contacto
Directorio
Afiliados