Database design of College Network System

This record contains the College Network Infrastructure Database Schedule. A data collection reflects an inherent sequence of knowledge, for a specific purpose, designed, generated and processed for such natural consequences. During the data set plan, the accompanying rules were followed:

  • Tables, lines and documents spellbinding titles
  • Tables and segments of lonely titles
  • Suitable type of information for each section

This record shows the tables used for the product planning, the credits, the type of details, the specifications and the link between them. The tables have to be linked via E-R diagram (Entity-Relationships). An E-R model is referred to as the diagrammatic representation of the relations between an entity and its ascriptions. The model of Trama Center focuses on developing data collection and data set strategy. In the plan of a reasonable trend in the data set plan, the Trama center model is basically used. An object with physical or logical appearance may be a material. The assets used to represent the element are referred to as credits. The fragile element groups are named elements that do not have their own primary credits. The bond between the fragile element and the owner is called the distinct link between the frail element form. A powerless entity form has an absolute limit on the acceptance of its relation.

Database name: Collegenetworking

Table name:- college

Database name: Collegenetworking

Table name:- college

Field

Type  Null   Description
 collegeid  bigint(10)  No  Id of the   college
 collegename  varchar(50)  No  Name of the   college 
 collegelocation  varchar(50)  No  Location of   the college

Table name:- image

Field

Type Null Description
imgid bigint(8) No Image Id
imagname varchar(20) No Name of the image
imgcategory varchar(20) No Image category
description varchar(50) No Image description
uploadimage varchar(25) No Path of the image


Table name:- pracdemo

Field

Type Null Description
videoid bigint(8) No Video Id
videoname varchar(25) No Name of the video
videosection varchar(25) No Section of the video
videosubject varchar(25) No Video subject
uploadvideo varchar(25) No Path of the video
description varchar(50) No Brief description of the video

Table name:- question answer

Field

Type Null Description
qid bigint(8) No Question Id
question varchar(50) No Question
answer varchar(70) No Correct answer
option1 varchar(70) No Option 1
option2 varchar(70) No Option 2
option3 varchar(70) No Option 3
option4 varchar(70) No Option 4
visible varchar(25) No If value of visible is true then user can answer for this question  otherwise not.

Table name:- question paper

Field

Type Null Description
paperid bigint(8) No Question Paper Id
Papername varchar(25) No Question paper name
subject varchar(20) No Subject name
section varchar(20) No Student Section name
description varchar(50) No Brief description of Question paper
upload varchar(50) No Path of the file
uploadtext text No Uploaded text file

Table name:- studentaccount

Field

Type Null Description
id bigint(8) No Student Account Id
first name varchar(25) No Student First name
last name varchar(25) No Student Last name
email varchar(30) No Student Email Id
password varchar(30) No Password
confirm password varchar(30) No Confirmation password
I am varchar(10) No Gender
dob Date No Date of Birth
 
For Source code of all projects visit https://www.studentprojectguide.com/

 

DOWNLOAD NOW 🔥335

FreeStudentProjects

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone. for more info please WhatsApp us on +91-9481545735 or Email id: freestudentprojectsindia@gmail.com

10 Comments

  • skano lux

    September 9, 2012 - 5:52 AM

    love to watch these again and again, trying to develop a social site for colleges in Ghana and all students in the world…………………….

  • Neha Shrama

    October 18, 2012 - 10:27 PM

    please send me full database table used in the
    College Network System….
    plz upload database……plzzzzz….

  • komal

    November 2, 2012 - 4:07 PM

    please send me full database table used in the
    College Network System….
    plz upload database……plzzzzz….

  • Dun

    December 19, 2012 - 11:33 AM

    great…..am trying to develop a social networking site for east africa universities and colleges…

  • Geetha

    December 23, 2012 - 2:29 PM

    i like this project. i can do. so please send me full database table used in the College Network System….
    plz upload database……plzzzzz….

  • gezeay

    March 26, 2013 - 12:02 AM

    please upload and send me full database table used in the
    College Network System.

  • gezeay

    March 26, 2013 - 12:09 AM

    please send me full documentation of the project that contains abstract, introduction,
    requirement analysis, design, implementation and testing.

  • sushila

    April 2, 2013 - 7:08 PM

    pleass tell me how it was overall performing how can i run this program

  • T-ghurl

    December 11, 2013 - 2:38 AM

    pls can i get the full documentation as in the introduction, abstract, requirement analysis, literature review, design, implementation, methodology and testing to my e-mail (timmieghurl@gmail.com)

  • ahmed

    October 18, 2016 - 5:36 PM

    pls can i get the full documentation as in the introduction, abstract, requirement analysis, literature review, design, implementation, methodology and testing to my e-mail amriahmed077@gmail.com

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.