Entity Relationship Diagram Analysis

In this project I have to roll up roughly entity, so an entity attributes and at last ERD.I ideate I lead take more(prenominal) than roughly entity, attributes, Entity blood plot to cast off this job.DescriptionEntityAn Entity is an object or substantial thing such as a tabular troops or kind. An Entity contains well-nigh education nearly himself. In the entity close to(a) developments screw be stored.PropertiesProperties means the info or inside knowledges of an Entity. Attribute whitethorn incorporate assorted sorts of value resembling numeral, Characters, Integer and so on Simply attributes ar the deceaseingss of entity.Entity family relativeship plot ( ERD )An entity- coincidenceship plot is a in shapeation mold plat and technique. ERD move direct a graphical theatrical of the everyiances between entities, the entities, and at heart an breeding agreement. there be ternion symbol affinitys in the Entity blood Diagram ( ERD ) iodine t o OneOne to more galore(postnominal) to ManyThe antique constituents of Entity family relationship Diagram ( ERD )EntityPropertiesrelationshipCardinalityEntities division sufficient subject field provide program talent assimilator every last(predicate)owanceExaminationConsequenceCoursework attendingAdvancementEntities with Properties divisionDepartment_ID ( PK )Department_NameDepartment_DetailsDepartment_LeaderDisciplineSubject_Area_ID ( PK )Subject_Area_LeaderSubject_Area_NameSubject_Area_DetailsDepartment_ID ( FK )EmployeeEmployee_ID ( PK )Employee_LeaderEmployee_TypeEmployee_NameEmployee_JoiningDateEmployee_AddressDepartment_ID ( FK )PlanProgram_ID ( PK )Program_LeaderProgram_NameProgram_TypeProgram_DetailsSubject_Area_ID ( FK )RegistrationRegistration_ID ( PK )Registration_DateRegistration_TypeRegistration_costFacultyModule_ID ( PK )Module_NameModule_LeaderModule_DetailsModule_Type schoolchild_ID ( FK )Program_ID ( FK )StudentStudent_ID ( PK )Student_NameStudent_TypeStuden t_DetailsStudent_AddressModule_ID ( FK )Registration_ID ( FK )ExaminationExam_ID ( PK )Exam_DetailsExam_NameExam_DateExam_TimeStudent_ID ( FK )ConsequenceResult_ID ( PK )Result_NameResult_TypeResult_DetailsResult_DateResult_timeExam_ID ( FK )CourseworkCoursework_ID ( PK )Coursework_NameCoursework_TypeCoursework_DetailsStudent_ID ( FK )AttendanceAttendance_ID ( PK )Attendance_NameAttendance_TypeAttendance_DetailsStudent_ID ( FK )AdvancementProgress_ID ( PK )Progress_TypeProgress_DetailsEntity Relationship Diagram ( ERD ) Relationship sum-upIn my ERD plot nearly relation exposition atomic number 18 attached in the belowIn the Entity Relationship Diagram I realise reveal the relation between segmentation and undecided untaught is i to some, because unitary sectionalization may exert many capable countries.In the scenario I can see ane capable country may hold more intends.In the ERD draw the kind between envision and skill is single to many. Many faculties ar under of a project. Module is utilise a immaterial key of patterns.In the ERD diagram the family affinity between savants and faculties argon nonp beil to many, because unrivaled learner may hold more than one cogency. In the relationship savant primary winding key is employ as a foreign key in the cogency entity.In the ERD diagram the relationship between scholarly person and test is one to many. One pupil may defer part more tests.In the ERD diagram the relationship between pupil and coursework is one to many. One pupil may take a crap part in the more coursework.In the ERD diagram the relationship between readjustment and pupil is one to many. The enrollment may be registers for more pupils at equivalent clip.In the ERD diagram safefully I see the one to many dealingss. For this back institute knowledge I entangle one to many relationships in the ERD diagram. In the existent animateness for database one to many relationship is thoroughgoing(a) to me.Drum headIn this initiate I contrive an entity relationship diagram. To reap the diagram I find out some entities and properties of entities. To sustain this lying-in I besides learn around entities, properties and entity relationship diagram.Task-02IntroductionIt is said to traffic patternise in the labour 2. For doing a database successfully calibration must be needed. The activities of a database seem on normalization. Standardization helps to do a database rebelliously. In the set about I leave look for to normalise for a section carcass in the transcription. The normalisation occurs in some stairss. In the undermentioned stairss atomic number 18 introducen.DescriptionStandardizationIn the organisation all activities now number on the computing forge dust. some(prenominal) corporate organisation need database ashes for commanding all information. As a mo database is most popular and subjective things in the universe. For doing a database successfully stan dardisation is the traditional stylus. Without standardization it is impossible to do a database. Standardization is the procedure is apply to form the informations absolutely in a database. I normalize the section information for some specific intent. The intent of standardization is divided into two parts. Removing unneeded informations and guaranting informations dependences. If equal informations stay in some tabular array together the database may victim. practically it may data in the unrelated tabular array. To work out these jobs we can be done standardization. The intents of standardization be praiseworthy to diminish the sum of interminable a database consumes and guarantee that information is logically stored. The overt presentation of database watchfulness constitution depends on the standardization. near stairss ar inherent for standardization. The stairss are given up briefly in the followers meeting place informationsGathering informations is the first c adency of standardization. When I normalize I forget roll up all information in the contour. I ordain hold all informations of this rate in the followers measure.Choosing a keyFor making standardization a key is indispensable. The key is the important informations for standardization. tout ensemble informations depend on the key. The key must be one from garnering informations.First convening grad ( 1NF ) whatever functions have to follow in the stairss. restate informations in the standardization, sometime it may bruising for standardization, so it necessary to take reiterating informations in the standardization. Removing reiterating informations is the chief work in this travail.Second prevalent family ( 2NF )Second normal signifier ( 2NF ) is used to different and take same informations in the database. The phase besides provides farther information for taking same informations in the database. The chief activities of the phaseThe all informations of first normal signifier must be delineated in the phase.Same information in the rows of database tabular array are distant in the phase.The relationship of unfermentedborn tabular array is do in the phase.Third frequent contrive ( 3NF )In the 3rd normal signifier some activities are occurred. The undermentioned activities are given in the below in all demands of the 2nd normal signifier are present in the phase.The activities of the phase is take some columns that are non dependent upon the primary key. The taking informations and information are non depended on the primary key of tabular array. For this ground these columns informations and information are removed.OptimizationOptimization is the last measure of standardization. I will blend in fore the self-colored standardization by bring forrading a standardization diagram. The standardization diagram is symbol of a go against database. If standardization tabular array is pull ahead, informations base become clear.Gathering Data sDepartment_IDDepartment_NameDepartment_DetailsDepartment_Leader loose Area_ID heart-to-heart Area_LeaderCapable Area_NameCapable Area_Detailsemployee_IDemployee_Leaderemployee _Typeemploye _Nameemployee_JoiningDateStaff_AddressProgramme_IDProgramme_LeaderProgramme_NameProgramme_TypeProgramme_DetailsStudent_IDRegistration_IDRegistration_DateRegistration_TypeModule_IDModule_NameModule_LeaderModule_DescriptionModule-TypeStudent_IDStudent_NameStudent_TypeStudent_DescriptionStudent_AddressModule_IDRegistration_IDExam_IDExam_DescriptionExam_NameExam_DateExam_TimeResult_IDResult_NameResult_TypeResult_DescriptionResult_DateResult_timeCoursework_ IDCoursework_NameCoursework_TypeCoursework_DetailsAttendance_IDAttendance_NameAttendance_TypeAttendance_DetailsProgress_IDProgress_TypeProgress_DetailsChoosing a keyStudent_idConverting to 1st regulation Form ( transpose to reiterating informations )Student ( retell ) Department_idDepartment_ figStudent_idStudent_ learnStudent_e turn onStudent_ rememberStudent_addressStudy_modeEmployee_idEmployee_ figureEmployee_phoneEmployee_emailEmployee_addresses internal activityProgram_idProgram_ divulgeProgram_timeCredit_idTotal_course_marksTotal_module_marksTotal_creditConsequenceModule_idModule_ divulgeModule_leaderModule_yearCapable Area ( Non Repeating ) Subjectarea_idSubjectarea_nameSubjectarea_LeaderConverting to 2nd Normal Form ( Remove parcel cardinal dependance )StudentStudent_id ( pk )Student nameStudent electronic mailStudentphoneStudent referenceStudy moodProgram Idaho ( fk )Programe namePlan leaderRecognitionRecognition Idaho ( pk )Student Idaho ( fk )Entire coursework material bodyExam gradeModule gradeEntire apprehensionConsequenceFacultyModule Idaho ( pkModule leaderFaculty namePrograme Idaho ( fk )Programe nameEmployeeEmployee Idaho ( pk )Employee nameEmployee electronic mailEmployee phoneEmployee referenceSexual activityDepatment Idaho ( fk )Department nameDepartmentDepartment Idaho ( pk )Department namePlanProgr am Idaho ( pk )Capable country Idaho ( fk )Capable country namePrograme namePlan leaderCapable countryCapable country Idaho ( pk )Capable country nameDepartment Idaho ( fk )Department nameCapable country leaderConverting to 3rd Normal Form ( Remove not cardinal dependence ) DepartmentDepartment_id ( PK )Department_nameCapable AreaSubjectarea_id ( PK )Subjectarea_nameDepartment_id ( FK )Subjectarea_Leader ( FK )EmployeeEmployee_id ( PK )Employee_nameEmployee_phoneEmployee_emailEmployee_addressesSexual activityDepartment_id ( FK )Student_moduleStudent_id ( PK )Module_id ( PK )PlanProgram_id ( PK )Subjetarea_id ( FK )Program_leader ( FK )Program_nameProgram_timeFacultyModule_id ( PK )Module_nameModule_leader ( FK )Module_yearProgram_id ( FK )StudentStudent_id ( PK )Student_nameStudent_emailStudent_phoneStudent_addressStudy_modeProgram_id ( FK )RecognitionCredit_id ( PK )Student_id ( FK )Module_id ( FK )Total_course_marksTotal_module_marksTotal_creditConsequenceOptimizationSummaryIn the undertaking I normalized for a section. I normalize for property database explosive charge schema. To make this undertaking I analyzed about standardization. I think I normalized good. light up standardization helps to do a better database direction system. I well-educated more about standardization to make this undertaking. labor movement 3IntroductionThe undertaking 3 contains some subjects. Database care brass ( DBMS ) is component of the undertaking. I will make a database by utilizing Database Management dust ( DBMS ) . thither are some ways to do database. exclusively I will make database in the SQL waiter, because it is easy and flexible to me. To do database I will do some tabular array, each tabular array will incorporate minimal 5 records.DescriptionSome stairss I followed to make this undertaking. The stairss and demands are given in the belowDatabase Management clay ( DBMS ) To pull off a database some strong functions are followed. Database direction system i s a sort of environs where all sorts functions and ordinance are included. A database direction system ( DBMS ) purpo located life as a database director. Database Management System ( DBMS ) is computing machine jut out or package. The package helps former(a)s computing machine drug users create and price of admission informations in a database. Anyone can entree the information, where information is fit(p) it is non fact, It get laids user petitions so that users and other plans are free from holding to understand informations in a multi-user system, on storage media and, who else may besides be accessing the information. Database direction system checks the unity of the database. The DBMS besides manage the hallmark procedure, merely authorized user and authorised web can entree the database. DBMS helps to do a unspoilt database. Database direction system s surroundings helps to do a good relationship in the database.The activities for this undertaking are pursuitMY d atabaseGenerated Script from Generate SQL Server Scripts friend go rectify ANSI_NULLS ON fail note QUOTED_IDENTIFIER ON travelingIF not EXISTS ( mete out * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . section ) AND eccentric person in ( NU ) ) annoy trim back give rise display panel dbo . section ( department_id nchar ( 10 ) not NULL, department_name nvarchar ( 50 ) NULL, shyness PK_department uncomplicated identify CLUSTERED( department_id ASC) WITH ( IGNORE_DUP_ rouge = take away ) ON ancient ) ON direct curiosity set off discipline ANSI_NULLS ON live driven QUOTED_IDENTIFIER ON get goingIF non EXISTS ( divide * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . employee ) AND type in ( NU ) ) scotch down puddle delay dbo . employee ( employee_id nchar ( 10 ) not NULL, employee_name nvarchar ( 50 ) NULL, employee_email nvarchar ( 50 ) NULL, employee_phon int NULL, employee_address nvarchar ( 50 ) NULL, department_id nchar ( 10 ) NULL, sex activity nvarchar ( 1 ) NULL, coldness PK_employee original break CLUSTERED( employee_id ASC) WITH ( IGNORE_DUP_KEY = mangle ) ON unproblematic ) ON main(a) End go away isthmus ANSI_NULLS ON breakSET QUOTED_IDENTIFIER ON operateIF NOT EXISTS ( assume * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . subjectarea ) AND type in ( NU ) )Get downCREATE tabularise dbo . subjectarea ( subjectarea_id nchar ( 10 ) NOT NULL, subjectarea_name nvarchar ( 50 ) NULL, department_id nchar ( 10 ) NOT NULL, subjectarea_leader nchar ( 10 ) NOT NULL, backwardness PK_subjectarea primeval KEY CLUSTERED( subjectarea_id ASC) WITH ( IGNORE_DUP_KEY = send off ) ON PRIMARY ) ON PRIMARY End run lowSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( make out * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . plan ) AND type in ( NU ) )Get downCREATE disconcert dbo . plan ( program_id nchar ( 10 ) NOT NULL, subjectarea_id nchar ( 10 ) NULL, program_name nvarchar ( 50 ) NULL, program_leader nchar ( 10 ) NULL, program_time nvarchar ( 50 ) NULL, unobtrusiveness PK_program PRIMARY KEY CLUSTERED( program_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( subscribe to * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . readiness ) AND type in ( NU ) )Get downCREATE card dbo . faculty ( module_id nchar ( 10 ) NOT NULL, program_id nchar ( 10 ) NULL, module_leader nchar ( 10 ) NULL, module_name nvarchar ( 50 ) NULL, twelvemonth nchar ( 10 ) NULL,CONSTRAINT PK_module PRIMARY KEY CLUSTERED( module_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( use up * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . pupil ) AND type in ( N U ) )Get downCREATE TABLE dbo . pupil ( student_id nchar ( 10 ) NOT NULL, student_name nvarchar ( 50 ) NULL, student_email nvarchar ( 50 ) NULL, student_phon int NULL, student_address nvarchar ( hundred ) NULL, program_id nchar ( 10 ) NULL, StudyMode nchar ( 10 ) NULL,CONSTRAINT PK_student PRIMARY KEY CLUSTERED( student_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( appoint * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . student_module ) AND type in ( NU ) )Get downCREATE TABLE dbo . student_module ( student_id nchar ( 10 ) NOT NULL, module_id nchar ( 10 ) NOT NULL,CONSTRAINT PK_student_module PRIMARY KEY CLUSTERED( student_id ASC, module_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( take aim * FROM sys.objects WHERE object_id = OBJEC T_ID ( N dbo . recognition ) AND type in ( NU ) )Get downCREATE TABLE dbo . recognition ( credit_id nchar ( 10 ) NOT NULL, student_id nchar ( 10 ) NULL, module_id nchar ( 10 ) NULL, total_coursework_marks int NULL, exam_marks int NULL, total_module_marks int NULL, total_credits int NULL, present moment nchar ( 10 ) NULL,CONSTRAINT PK_credit PRIMARY KEY CLUSTERED( credit_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_employee_department ) AND parent_object_id = OBJECT_ID ( N dbo . employee ) ) substitute TABLE dbo . employee WITH add together tot up CONSTRAINT FK_employee_department immaterial KEY ( department_id )REFERENCES dbo . section ( department_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_subjectarea_department ) AND parent_object_id = OBJE CT_ID ( N dbo . subjectarea ) ) switch TABLE dbo . subjectarea WITH CHECK lend CONSTRAINT FK_subjectarea_department unconnected KEY ( department_id )REFERENCES dbo . section ( department_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_subjectarea_employee ) AND parent_object_id = OBJECT_ID ( N dbo . subjectarea ) ) veer TABLE dbo . subjectarea WITH CHECK append CONSTRAINT FK_subjectarea_employee inappropriate KEY ( subjectarea_leader )REFERENCES dbo . employee ( employee_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_program_employee ) AND parent_object_id = OBJECT_ID ( N dbo . plan ) ) motley TABLE dbo . plan WITH CHECK loan CONSTRAINT FK_program_employee FOREIGN KEY ( program_leader )REFERENCES dbo . employee ( employee_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_program_subjectarea ) AND parent_object_id = OBJECT_ID ( N dbo . plan ) )ALTER TABLE dbo . plan WITH CHECK tote up CONSTRAINT FK_program_subjectarea FOREIGN KEY ( subjectarea_id )REFERENCES dbo . subjectarea ( subjectarea_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_module_employee ) AND parent_object_id = OBJECT_ID ( N dbo . faculty ) )ALTER TABLE dbo . faculty WITH CHECK ADD CONSTRAINT FK_module_employee FOREIGN KEY ( module_leader )REFERENCES dbo . employee ( employee_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_module_program ) AND parent_object_id = OBJECT_ID ( N dbo . faculty ) )ALTER TABLE dbo . faculty WITH CHECK ADD CONSTRAINT FK_module_program FOREIGN KEY ( program_id )REFERENCES dbo . plan ( program_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT _ID ( N dbo . FK_student_program ) AND parent_object_id = OBJECT_ID ( N dbo . pupil ) )ALTER TABLE dbo . pupil WITH CHECK ADD CONSTRAINT FK_student_program FOREIGN KEY ( program_id )REFERENCES dbo . plan ( program_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_student_module_module ) AND parent_object_id = OBJECT_ID ( N dbo . student_module ) )ALTER TABLE dbo . student_module WITH CHECK ADD CONSTRAINT FK_student_module_module FOREIGN KEY ( module_id )REFERENCES dbo . faculty ( module_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_student_module_student ) AND parent_object_id = OBJECT_ID ( N dbo . student_module ) )ALTER TABLE dbo . student_module WITH CHECK ADD CONSTRAINT FK_student_module_student FOREIGN KEY ( student_id )REFERENCES dbo . pupil ( student_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign _keys WHERE object_id = OBJECT_ID ( N dbo . FK_credit_module ) AND parent_object_id = OBJECT_ID ( N dbo . recognition ) )ALTER TABLE dbo . recognition WITH CHECK ADD CONSTRAINT FK_credit_module FOREIGN KEY ( module_id )REFERENCES dbo . faculty ( module_id )TravelIF NOT EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID ( N dbo . FK_credit_student ) AND parent_object_id = OBJECT_ID ( N dbo . recognition ) )ALTER TABLE dbo . recognition WITH CHECK ADD CONSTRAINT FK_credit_student FOREIGN KEY ( student_id )REFERENCES dbo . pupil ( student_id )SummaryI used SQL waiter for doing database. I draw the diagram by utilizing normalized diagram. Some tabular arraies I created to bring forrard the diagram of database. I included all defer mean five records. To make the undertaking absolutely I show all tabular arraies screen shot with records.Undertaking 4IntroductionThe chief activities are said in the undertaking. In the u ndertaking I will quire of my database. straight off in the undertaking I will seek to implement. I will range the operation of database. I will quire of the database harmonizing the medical prognosis of the undertaking. I will follow the activities harmonizing the undertaking.DescriptionIn the undertaking I have to make questions for find out some demands these are said to make in the undertaking. In the undermentioned these activities are given in the below1.Name callings of all the Subject Area Leaders ( SALs )QuerieSELECT dbo.subjectarea.subjectarea_leader, dbo.employee.employee_name, dbo.subjectarea.subjectarea_nameFROM dbo.employee inside(a) spliffdbo.subjectarea ON dbo.employee.employee_id = dbo.subjectarea.subjectarea_leaderEnd point of intersectionPLs along with the name ( s ) of the capable countryQuerieSELECT dbo.program.program_leader, dbo.employee.employee_id, dbo.program.program_nameFROM dbo.employee inside join forcesdbo.program ON dbo.employee.employee_id = d bo.program.program_leaderEnd convergenceMLs along with the name ( s ) of the capable countrySELECT dbo.module.module_leader, dbo.employee.employee_name, dbo.module.module_nameFROM dbo.employee internal nitty-grittydbo.module ON dbo.employee.employee_id = dbo.module.module_leader2. Expose the undermentioned information for the Artificial Intelligence capable countrya ) The tendency of plans that belong to that capable country QuerieSELECT program_nameFROM dbo.programWHERE ( subjectarea_id = sa-03 )End productB ) The list of faculties that belong to these plans QuerieSELECT dbo.program.program_id, dbo.module.module_nameFROM dbo.program home(a) yokedbo.module ON dbo.program.program_id = dbo.module.program_idWHERE ( dbo.program.subjectarea_id = sa-03 )degree Celsius ) The list of pupils who have awarded a Pass for one of the facultiesQuerieSELECT evident C.student_id, student.student_name, C.module_id, module.module_name, C.resultFROM recognition AS C INNER JOINfaculty ON C.m odule_id = module.module_id INNER JOINpupil ON C.student_id = student.student_id INNER JOINplan ON module.program_id = program.program_id AND student.program_id = program.program_id INNER JOINsubjectarea ON program.subjectarea_id = subjectarea.subjectarea_idWHERE ( C.result = pass ) AND ( subjectarea.subjectarea_id = sa-03 )End product3. Expose the name of all the pupils who belong to one plan you can take which plan of the Database capable country, along with the undermentioned informationa ) Their twelvemonth of survey QuerieSELECT DISTINCT dbo.student.student_id, dbo.student.student_name, dbo.program.program_id, dbo.program.program_name, dbo.module.yearFROM dbo.student INNER JOINdbo.program ON dbo.student.program_id = dbo.program.program_id INNER JOINdbo.module ON dbo.program.program_id = dbo.module.program_id INNER JOINdbo.student_module ON dbo.student.student_id = dbo.student_module.student_id AND dbo.module.module_id = dbo.student_module.module_idWHERE ( dbo.program.subj ectarea_id = sa-01 )End productB ) The faculties they write up QuerieSELECT DISTINCTdbo.student.student_id, dbo.student.student_name, dbo.module.module_name, dbo.student_module.module_id, dbo.student.program_id,dbo.program.program_nameFROM dbo.student INNER JOINdbo.program ON dbo.student.program_id = dbo.program.program_id INNER JOINdbo.module ON dbo.program.program_id = dbo.module.program_id INNER JOINdbo.student_module ON dbo.student.student_id = dbo.student_module.student_id AND dbo.module.module_id = dbo.student_module.module_idWHERE ( dbo.program.subjectarea_id = sa-01 )End productdegree Celsiuss ) Their test and coursework Markss for these facultiesQuerieSELECT dbo.credit.student_id, dbo.student.student_name, dbo.credit.module_id, dbo.module.module_name, dbo.credit.total_coursework_marks, dbo.credit.exam_marks, dbo.student.program_idFROM dbo.credit INNER JOINdbo.module ON dbo.credit.module_id = dbo.module.module_id INNER JOINdbo.student ON dbo.credit.student_id = dbo.studen t.student_id INNER JOINdbo.program ON dbo.module.program_id = dbo.program.program_id AND dbo.student.program_id = dbo.program.program_idwhere program.subjectarea_id=sa-01 End productSummarySome quires are done in the undertaking harmonizing the functions of grant. I finished the undertaking rightfully carefully. As a proven I show some screen jibe of quires. I besides show SQL quires in the assignment.Undertaking 5IntroductionThere are five undertakings in the assignment. Each undertaking is made for a specific and different subject. Such a undertaking is task 5. In the undertaking 5 I will seek to stand for a bailiwick for self-colored assignment. The contemplate will incorporate the translation of my system design for a section of an organisation. In this study I will besides include the inside informations information about undertaking one to five.DescriptionIn the phase I will seek to give a solution for this study.TitleReport no- Database Design and knowledgeRecipient- Mrs Jesmin AktarAuthor- Shanta MariaIntroduction of my premiseThe rubric of the assignment is College Database Development. The college necessitate a calculatorized system for guardianship the activities of a section. To charge the section activities the college needs an nonesuch database direction system. To complete these activities of this assignment I mentioned each subject for the assignment in the separately. I think I learned more things as pupil, to make this assignment. subsequently completing each undertaking right I will bring forth a study for discover my exercise on my summary, design and thought accomplishment.Overview of whole assignmentThe sum-up of the whole assignment, I compulsion to bring forth a study. The study is given at the belowUndertaking 1EntityAn Entity is a existent thing such as a tabular array or signifier. An Entity contains some information about himself. The information of entity can assist for style of entity.PropertiesAttributes refers the inside informations information of an Entity. There are many types are fixed for property. These set are like numeral, Characters, Integer etc. Properties are the chief belongings of entities.Entity Relationship Diagram ( ERD )An entity-relationship diagram is a diagram for informations patterning. Entity relationship diagram ensures the relationships between entities, the entities, and within an information system. Entity relationship diagram makes a database good understand.There are three type relationships in the Entity Relationship Diagram ( ERD )One to OneOne to ManyMany to ManyThe chief constituents of Entity Relationship Diagram ( ERD )EntityPropertiesRelationshipCardinalityUndertaking 2StandardizationSome corporate organisation need database system for commanding all information. To command information of organisation database must be needed. As a consequence database is most popular and indispensable things in the universe. Without standardization it is impossible to do a database. Standardization is the procedure is used to form the informations absolutely in a database. I normalize the section information for some specific intent. The intents of standardization are worthy to diminish the sum of infinite a database consumes and guarantee that information is logically stored. The public presentation of database direction system depends on the standardization.Some stairss are indispensable for standardization.In the assignment I followed some stairss for standardization. The stairss are given in the belowGathering informationsChoosing a keyFirst Normal Form ( 1NF )Second Normal Form ( 2NF )Third Normal Form ( 3NF )OptimizationUndertaking 3I used SQL waiter to do database in this undertaking. fashioning database was the function of the undertaking. As a consequence I designed a diagram and a database in the undertaking.Undertaking 4The undertaking holds information for SQL quires. Harmonizing the undertaking some quires are made to use in the da tabase. To make SQL quires in the undertaking I learned more things about SQL bid and other dear information of SQL waiter.Footings of mentionThe scope for investigated system is extended. All the inside informations about the system hold given. The incumbent system and the new system image are clear in the scenario. Anyone can see and analyze the scenario.The study focuses on the section of an organisation. The study is bring forthing with a inside informations description and information of the complete system analysis and design portion for the section of an organisation.Procedures and methodsIn my assignment I used some techniques. I have investigated all the offshoot in many ways. In the assignment I followed the operation and practically system of college and others pull offing activities. The chief do and method of the assignment is to settle the current system jobs and besides to present an model database system of the academy theatre for keeping the section procedure. In this assignment I used entity relationship diagram and other demands and processs.RecommendationHarmonizing the users demands and after probe the system, I could transcend out some jobs and some other job in the college development diagram. The keeping system of the college development diagram was really hard to pull off. To work out the jobs I provide the new IT system. I will seek and bring forth the really easy manner to pull off the college development diagram for keeping procedure or systems in the new database system of College Database Development.Requirement computer hardware To set up the procedure some hardware and package are really indispensable. The name or hardware demands are given in the followersPersonal computer ( Include all hardware ) mesh topology ConnectionSQL waiterWindows XP.NET modelFuture program for my databaseIn the assignment I produced a database direction system for a college section. There are many sections of the college. I will include more info rmation about more sections in the database at future. To implement my database I will utilize latest tools. I will seek to happen how manner I can implement the database.AppendixEntity Relationship Diagram ( ERD ) Optimization diagramDatabaseSummaryThere are five undertakings in the assignment. The assignment contains some subjects of database. As a pupil any one can larn about database direction system from the topic. The undertaking five contains information of an premise. In the undertaking I tried to supply an high-flown premise about the whole assignment.