Database Diagram Designing For Free Application for Various School

Database Diagram Designing For Free Application for Various School:-

This article will explain for SQL Developer and Database Architecture Designer to design the Database for School or Couching or Any academic center.

 To demonstrate this, I have created for tables
1- Student

Student
StudentID	Name	UID
1	Bill Gate	1100110001
2	SAM	1100110002
3	Jastin	1100110004
4	Bejos	1100110015
5	Rohit	1100110016
6	Sachin	1100110020
7	Virat	1100110021
8	Modi	1100110023
9	Trump	1100110026
10	Putin	1100110030

 

2- Standard

Standard
StandardID	Name
1	I
2	II
3	III
4	IV
5	V
6	VI
7	VII
8	VIII
9	IX
10	X
11	XI
12	XII

 

3- CENTER/ School/ Branch/ Location

CENTER
CenterID	Center
1	INDIA
2	US
3	CANADA
4	RUSSIA
5	UK

 

4-ANNUAL Charges

ANNUAL Charges
ACID	CenterID	StandardID	CHARGES($)
1	1	I	100
2	1	II	120
3	1	III	140
4	1	IV	160
5	1	V	180
6	1	VI	200
7	1	VII	220
8	1	VIII	240
9	1	IX	260
10	1	X	280
11	1	XI	300
12	1	XII	320
13	2	I	1000
14	2	II	1200
15	2	III	1400
16	2	IV	1600
17	2	V	1800
18	2	VI	2000
19	2	VII	2200
20	2	VIII	2400
21	2	IX	2600
22	2	X	2800
23	2	XI	3000
24	2	XII	3200
25	3	I	500
26	3	II	750
27	3	III	1000
28	3	IV	1250
29	3	V	1500
30	3	VI	1750
31	3	VII	2000
32	3	VIII	2250
33	3	IX	2500
34	3	X	2750
35	3	XI	3000
36	3	XII	3250
37	4	I	500
38	4	II	550
39	4	III	600
40	4	IV	650
41	4	V	700
42	4	VI	750
43	4	VII	800
44	4	VIII	850
45	4	IX	900
46	4	X	950
47	4	XI	1000
48	4	XII	1050
49	5	I	1100
50	5	II	1200
51	5	III	1300
52	5	IV	1400
53	5	V	1500
54	5	VI	1600
55	5	VII	1700
56	5	VIII	1800
57	5	IX	1900
58	5	X	2000
59	5	XI	2100
60	5	XII	2200

 

 Now to Design the Database Diagram for any Organization, First we need to check up to which level we need to create the flexibility. 

1- If all data is static then we should use the  one- to one- relationship

2- If we required full flexibility then we should use many-to-many relationship.

MS SQL Server Error Types 2

Error Type =5001,/n Error Description User must be in the master database.. Error Severity  Level=16

Error Type =5002, Error Description Database '%.*ls' does not exist. Check sysdatabases.. Error Severity  Level=16

Error Type =5004, Error Description To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed.. Error Severity  Level=16

Error Type =5005, Error Description Extending database by %.2f MB on disk '%.*ls'.. Error Severity  Level=10

Error Type =5006, Error Description Could not get exclusive use of %S_MSG '%.*ls' to perform the requested operation.. Error Severity  Level=16

Error Type =5008, Error Description This ALTER DATABASE statement is not supported.. Error Severity  Level=16

Error Type =5009, Error Description ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly before rerunning the statement.. Error Severity  Level=16

Error Type =5010, Error Description Log file name cannot be generated from a raw device. The log file name and path must be specified.. Error Severity  Level=16

Error Type =5011, Error Description User does not have permission to alter database '%.*ls'.. Error Severity  Level=14

Error Type =5012, Error Description The name of the primary filegroup cannot be changed.. Error Severity  Level=16

Error Type =5013, Error Description The master and model databases cannot have files added to them. ALTER DATABASE was aborted.. Error Severity  Level=16

Error Type =5014, Error Description The %S_MSG '%.*ls' does not exist in database '%.*ls'.. Error Severity  Level=16

Error Type =5015, Error Description ALTER DATABASE failed. The total size specified must be 1 MB or greater.. Error Severity  Level=16

Error Type =5016, Error Description System databases master, model, and tempdb cannot have their names changed.. Error Severity  Level=16

Error Type =5017, Error Description ALTER DATABASE failed. Database '%.*ls' was not created with 'FOR LOAD' option.. Error Severity  Level=16

Error Type =5018, Error Description File '%.*ls' modified in sysaltfiles. Delete old file after restarting SQL Server.. Error Severity  Level=0

Error Type =5019, Error Description Cannot find entry in sysaltfiles for file '%.*ls'.. Error Severity  Level=10

Error Type =5020, Error Description The primary data or log file cannot be removed from a database.. Error Severity  Level=16

Error Type =5021, Error Description The %S_MSG name '%.*ls' has been set.. Error Severity  Level=10

Error Type =5022, Error Description Log file '%ls' for this database is already active.. Error Severity  Level=16

Error Type =5023, Error Description Database must be put in bypass recovery mode to rebuild the log.. Error Severity  Level=16

Error Type =5024, Error Description No entry found for the primary log file in sysfiles1. Could not rebuild the log.. Error Severity  Level=16

Error Type =5025, Error Description The file '%ls' already exists. It should be renamed or deleted so that a new log file can be created.. Error Severity  Level=16

Error Type =5026, Error Description Could not create a new log file with file '%.*ls'. See previous errors.. Error Severity  Level=16

Error Type =5027, Error Description System databases master, model, and tempdb cannot have their logs rebuilt.. Error Severity  Level=16

Error Type =5028, Error Description The system could not activate enough of the database to rebuild the log.. Error Severity  Level=16

Error Type =5029, Error Description Warning: The log for database '%.*ls' has been rebuilt. Transactional consistency has been lost. DBCC CHECKDB should be run to validate physical consistency. Database options will have to be reset, and extra log files may need to be deleted.. Error Severity  Level=10

Error Type =5030, Error Description The database could not be exclusively locked to perform the operation.. Error Severity  Level=16

Error Type =5031, Error Description Cannot remove the file '%.*ls' because it is the only file in the DEFAULT filegroup.. Error Severity  Level=16

Error Type =5032, Error Description The file cannot be shrunk below page %ud until the log is backed up because it contains bulk logged pages.. Error Severity  Level=10

Error Type =5035, Error Description Filegroup '%.*ls' already exists in this database.. Error Severity  Level=16

Error Type =5036, Error Description MODIFY FILE failed. Specify logical name.. Error Severity  Level=16

Error Type =5037, Error Description MODIFY FILE failed. Do not specify physical name.. Error Severity  Level=16

Error Type =5038, Error Description MODIFY FILE failed for file "%.*ls". At least one property per file must be specified.. Error Severity  Level=16

Error Type =5039, Error Description MODIFY FILE failed. Specified size is less than current size.. Error Severity  Level=16

Error Type =5040, Error Description MODIFY FILE failed. Size is greater than MAXSIZE.. Error Severity  Level=16

Error Type =5041, Error Description MODIFY FILE failed. File '%.*ls' does not exist.. Error Severity  Level=16

Error Type =5042, Error Description The %S_MSG '%.*ls' cannot be removed because it is not empty.. Error Severity  Level=16

Error Type =5043, Error Description The %S_MSG '%.*ls' cannot be found in %ls.. Error Severity  Level=16

Error Type =5044, Error Description The %S_MSG '%.*ls' has been removed.. Error Severity  Level=10

Error Type =5045, Error Description The %S_MSG already has the '%ls' property set.. Error Severity  Level=16

Error Type =5046, Error Description The %S_MSG property '%ls' has been set.. Error Severity  Level=10

Error Type =5047, Error Description Cannot change the READONLY property of the PRIMARY filegroup.. Error Severity  Level=16

Error Type =5048, Error Description Cannot add, remove, or modify files in filegroup '%.*ls'. The filegroup is read-only.. Error Severity  Level=16

Error Type =5049, Error Description Cannot extend file '%ls' using this syntax as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE.. Error Severity  Level=16

Error Type =5050, Error Description Cannot change the properties of empty filegroup '%.*ls'. The filegroup must contain at least one file.. Error Severity  Level=16

Error Type =5051, Error Description Cannot have a filegroup with the name 'DEFAULT'.. Error Severity  Level=16

Error Type =5053, Error Description The maximum of %ld filegroups per database has been exceeded.. Error Severity  Level=16

Error Type =5054, Error Description Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.. Error Severity  Level=16

Error Type =5055, Error Description Cannot add, remove, or modify file '%.*ls'. The file is read-only.. Error Severity  Level=16

Error Type =5056, Error Description Cannot add, remove, or modify a file in filegroup '%.*ls' because the filegroup is offline.. Error Severity  Level=16

Error Type =5057, Error Description Cannot add, remove, or modify file '%.*ls' because it is offline.. Error Severity  Level=16

Error Type =5058, Error Description Option '%.*ls' cannot be set in database '%.*ls'.. Error Severity  Level=16

Error Type =5059, Error Description Database '%.*ls' is in transition. Try the ALTER DATABASE statement later.. Error Severity  Level=16

Error Type =5060, Error Description Nonqualified transactions are being rolled back. Estimated rollback completion: %d%%.. Error Severity  Level=10

Error Type =5061, Error Description ALTER DATABASE failed because a lock could not be placed on database '%.*ls'. Try again later.. Error Severity  Level=16

Error Type =5062, Error Description Option '%.*ls' cannot be set at the same time as another option setting.. Error Severity  Level=16

Error Type =5063, Error Description Database '%.*ls' is in warm standby. A warm-standby database is read-only.. Error Severity  Level=16

Error Type =5064, Error Description Changes to the state or options of database '%.*ls' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.. Error Severity  Level=16

Error Type =5065, Error Description Database '%.*ls' cannot be opened.. Error Severity  Level=16

Error Type =5066, Error Description Database options single user and dbo use only cannot be set at the same time.. Error Severity  Level=16

Error Type =5068, Error Description Failed to restart the current database. The current database is switched to master.. Error Severity  Level=10

Error Type =5069, Error Description ALTER DATABASE statement failed.. Error Severity  Level=16

Error Type =5070, Error Description Database state cannot be changed while other users are using the database '%.*ls'. Error Severity  Level=16

Error Type =5072, Error Description ALTER DATABASE failed. The default collation of database '%.*ls' cannot be set to %.*ls.. Error Severity  Level=16

Error Type =5073, Error Description Cannot alter collation for database '%ls' because it is READONLY, OFFLINE, or marked SUSPECT.. Error Severity  Level=16

Error Type =5074, Error Description The 'Primary Key Constraint Name' is dependent on 'Primary Key Column Name'.. Error Severity  Level=16

Error Type =5075, Error Description The %S_MSG '%.*ls' is dependent on %S_MSG.. Error Severity  Level=16

Error Type =5076, Error Description Warning: Changing default collation for database '%.*ls', which is used in replication. It is recommend that all replication database have the same default collation.. Error Severity  Level=10

Error Type =, Error Description The Publisher could not be created at this time.. Error Severity  Level=16

Error Type =Error, Error Description Description. Error Severity  Level=Severity

Error Type =5101, Error Description You must supply parameters for the DISK %hs statement. Usage: %hs.. Error Severity  Level=15

Error Type =5102, Error Description No such statement DISK %.*ls.. Error Severity  Level=15

Error Type =5103, Error Description MAXSIZE cannot be less than SIZE for file '%ls'.. Error Severity  Level=16

Error Type =5104, Error Description File '%.*ls' already used.. Error Severity  Level=16

Error Type =5105, Error Description Device activation error. The physical file name '%.*ls' may be incorrect.. Error Severity  Level=16

Error Type =5106, Error Description Parameter '%hs' requires value of data type '%hs'.. Error Severity  Level=15

Error Type =5107, Error Description Value is wrong data type for parameter '%hs' (requires data type '%hs').. Error Severity  Level=15

Error Type =5108, Error Description Log file '%.*ls' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.. Error Severity  Level=10

Error Type =5109, Error Description No such parameter '%.*ls'.. Error Severity  Level=16

Error Type =5110, Error Description File '%.*ls' is on a network device not supported for database files.. Error Severity  Level=16

Error Type =5116, Error Description You do not have permission to run DISK statements.. Error Severity  Level=14

Error Type =5117, Error Description Could not run DISK statement. You must be in the master database to run this statement.. Error Severity  Level=16

Error Type =5122, Error Description Each disk file size must be greater than or equal to 1 MB.. Error Severity  Level=10

Error Type =5123, Error Description CREATE FILE encountered operating system error %ls while attempting to open or create the physical file '%.*ls'.. Error Severity  Level=16

Error Type =5126, Error Description The logical device '%.*ls' does not exist in sysdevices.. Error Severity  Level=16

Error Type =5146, Error Description The %hs of %d is out of range. It must be between %d and %d.. Error Severity  Level=16

Error Type =5148, Error Description Could not set the file size to the desired amount. The operating system file size limit may have been reached.. Error Severity  Level=16

Error Type =5149, Error Description MODIFY FILE encountered operating system error %ls while attempting to expand the physical file.. Error Severity  Level=16

Error Type =5150, Error Description The size of a single log file must not be greater than 2 TB.. Error Severity  Level=16

Error Type =5151, Error Description The %hs statement is obsolete and no longer supported.. Error Severity  Level=16

Error Type =5157, Error Description I/O error encountered in the writelog system function during backout.. Error Severity  Level=16

Error Type =5158, Error Description Warning: Media in device '%.*ls' may have been changed.. Error Severity  Level=10

Error Type =5159, Error Description Operating system error %.*ls on device '%.*ls' during %ls.. Error Severity  Level=16

Error Type =5160, Error Description Cannot take '%.*ls' offline because the database is in use.. Error Severity  Level=16

Error Type =5162, Error Description Cannot find '%.*ls' in sysdatabases.. Error Severity  Level=16

Error Type =5163, Error Description Cannot open '%.*ls' to take offline.. Error Severity  Level=16

Error Type =5164, Error Description Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE). Error Severity  Level=16

Error Type =5165, Error Description Cannot explicitly open or close master database.. Error Severity  Level=16

Error Type =5167, Error Description Database '%.*ls' is already offline.. Error Severity  Level=16

Error Type =5168, Error Description File '%.*ls' is on a network drive, which is not allowed.. Error Severity  Level=16

Error Type =5169, Error Description FILEGROWTH cannot be greater than MAXSIZE for file '%.*ls'.. Error Severity  Level=16

Error Type =5170, Error Description Cannot create file '%ls' because it already exists.. Error Severity  Level=16

Error Type =5171, Error Description %.*ls is not a primary database file.. Error Severity  Level=16

Error Type =5172, Error Description The header for file '%ls' is not a valid database file header. The %ls property is incorrect.. Error Severity  Level=16

Error Type =5173, Error Description Cannot associate files with different databases.. Error Severity  Level=16

Error Type =5174, Error Description Each file size must be greater than or equal to 512 KB.. Error Severity  Level=10

Error Type =5175, Error Description The file '%.*ls' has been expanded to prevent recovery from failing. Contact the system administrator for further assistance.. Error Severity  Level=10

Error Type =5176, Error Description The file '%.*ls' has been expanded beyond its maximum size to prevent recovery from failing. Contact the system administrator for further assistance.. Error Severity  Level=10

Error Type =5177, Error Description Encountered an unexpected error while checking the sector size for file '%.*ls'. Check the SQL Server error log for more information.. Error Severity  Level=16

Error Type =5178, Error Description Cannot use file '%.*ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.. Error Severity  Level=16

Error Type =5179, Error Description Cannot use file '%.*ls', which is on a device with sector size %d. SQL Server supports a maximum sector size of 4096 bytes.. Error Severity  Level=16

Error Type =5180, Error Description Could not open FCB for invalid file ID %d in database '%.*ls'.. Error Severity  Level=22

Error Type =5181, Error Description Could not restart database '%.*ls'. Reverting back to old status.. Error Severity  Level=16

Error Type =5182, Error Description New log file '%.*ls' was created.. Error Severity  Level=16

Error Type =5183, Error Description File '%ls' cannot be created. Use WITH MOVE to specify a usable physical file name.. Error Severity  Level=16

Error Type =5184, Error Description Cannot use file '%.*ls' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.. Error Severity  Level=16

Error Type =5701, Error Description Changed database context to '%.*ls'.. Error Severity  Level=10

Error Type =5702, Error Description SQL Server is terminating this process.. Error Severity  Level=10

Error Type =5703, Error Description Changed language setting to %.*ls.. Error Severity  Level=10

Error Type =5803, Error Description Unknown config number (%d) in sysconfigures.. Error Severity  Level=10

Error Type =5804, Error Description Character set, sort order, or collation cannot be changed because at least one database is not writable.. Error Severity  Level=16

Error Type =5805, Error Description Too few locks specified. Minimum %d.. Error Severity  Level=16

Error Type =5807, Error Description Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5808, Error Description Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5809, Error Description Average time slices above %d milliseconds not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5810, Error Description Valid values for the fill factor are 0 to 100.. Error Severity  Level=16

Error Type =5812, Error Description You do not have permission to run the RECONFIGURE statement.. Error Severity  Level=14

Error Type =5823, Error Description Cannot reconfigure SQL Server to use sort order ID %d, because the row for that sort order does not exist in syscharsets.. Error Severity  Level=16

Error Type =5828, Error Description User connections are limited to %d.. Error Severity  Level=16

Error Type =5829, Error Description The specified user options value is invalid.. Error Severity  Level=16

Error Type =5830, Error Description The default collation for SQL Server has been reconfigured. Restart SQL Server to rebuild the table indexes on columns of character data types.. Error Severity  Level=10

Error Type =5831, Error Description Minimum server memory value (%d) must be less than or equal to the maximum value (%d).. Error Severity  Level=16

Error Type =5904, Error Description Background checkpoint process suspended until locks are available.. Error Severity  Level=17