Django ORM Web Application

AIM

To develop a Django application to store and retrieve data from a database using Object Relational Mapping(ORM).

Entity Relationship Diagram

Include your ER diagram here

DESIGN STEPS

STEP 1:

Install myapp using command prompt

STEP 2:

Edit setting.py and model.py

STEP 3:

create a username and password using for your django 'python manage.py createsuperuser' and then run the program using python manage.py runserver [your port number]"

STEP 4:

Login with your username and passowrd in django and select student table and then add 10 students details.

STEP 5:

End the program

PROGRAM

code to edit in 'models.py'

from django.db import models

from django.contrib import admin

Create your models here.

class Student (models.Model):
referencenumber=models.CharField(primary_key=True,max_length=20,help_text="reference number")
name=models.CharField(max_length=100)
age=models.IntegerField()
email=models.EmailField()
mobileno=models.IntegeField()

class StudentAdmin(admin.ModelAdmin):list_display=('referencenumber','name','age','email','mobileno')

codes to be edit in 'admin.py'

from django.contrib import admin from .models import Student,StudentAdmin

Register your models here.

admin.site.register(Student,StudentAdmin)

OUTPUT

RESULT

The program is executed successfully