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. |
Table name:- questionpaper
| 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 |
| firstname | varchar(25) | No | Student First name |
| lastname | varchar(25) | No | Student Last name |
| varchar(30) | No | Student Email Id | |
| password | varchar(30) | No | Password |
| confirmpassword | varchar(30) | No | Confirmation password |
| iam | varchar(10) | No | Gender |
| dob | Date | No | Date of Birth |
Comments ( 10 )
love to watch these again and again, trying to develop a social site for colleges in Ghana and all students in the world…………………….
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….
great…..am trying to develop a social networking site for east africa universities and colleges…
i like this project. i can do. so please send me full database table used in the College Network System….
plz upload database……plzzzzz….
please upload and send me full database table used in the
College Network System.
please send me full documentation of the project that contains abstract, introduction,
requirement analysis, design, implementation and testing.
pleass tell me how it was overall performing how can i run this program
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]