Database design of College Network System involves creating a database structure that is optimized for efficient data storage and retrieval. It includes designing tables, data types, relationships, stored procedures, and triggers. The database should also include security measures to ensure the data is not accessed by unauthorized users. When designing a database for a college network system, it is important to consider the size of the network, the types of data that will be stored, the frequency of data updates, and the purpose of the network. Some important considerations include scalability, redundancy, performance, and security. Additionally, the database should be normalized and properly indexed to ensure efficient data access.
This document covers Database design of College Network System. A database is an inherent collection of data with some inherent meanings, designed, built, and populated with data for a specific purpose. The following guidelines are been followed during the database design:
Descriptive names for the tables, columns and indexes
Singular names for tables and columns
Proper data type for each column
This document describes the tables that are used to design the software, its attributes, data type, constraints, and relationship among these tables. The relationships among tables are defined via E-R Diagram (Entity-Relationships). A diagrammatical representation of relationships between an entity and its attributes is referred to as E-R model. ER model concentrates on the structure of the database and design of the database. ER model is mainly used in the design of the conceptual schema in database design. An entity may be an object with physical or conceptual existence. The properties that are used to describe the entity are called attributes. Entities that do not have key attributes of their own are called weak entity type. The relationship type that relates a weak entity to its owner is called identifying relation of the weak entity type. A weak entity type always has a total participation constraint with respect to its identifying relation.
Database name: Collegenetworking
Table name:- college
Database design of College Network System
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:- questionanswer
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.
10 thoughts on “Database design of College Network System”
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 [email protected]
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 ([email protected])
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 [email protected]
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 ([email protected])
pleass tell me how it was overall performing how can i run this program
please send me full documentation of the project that contains abstract, introduction,
requirement analysis, design, implementation and testing.
please upload and send me full database table used in the
College Network System.
i like this project. i can do. so please send me full database table used in the College Network System….
plz upload database……plzzzzz….
great…..am trying to develop a social networking site for east africa universities and colleges…
please send me full database table used in the
College Network System….
plz upload database……plzzzzz….
please send me full database table used in the
College Network System….
plz upload database……plzzzzz….
love to watch these again and again, trying to develop a social site for colleges in Ghana and all students in the world…………………….