Entity Relationship Diagram Analysis

In this confinement I have to collect up approximately entity, so an entity attributes and at last ERD.I think I get out larn more(prenominal) round entity, attributes, Entity kindred diagram to murder this pioneer.DescriptionEntityAn Entity is an object or existent thing such(prenominal) as a tabular array or signifier. An Entity contains more or less study well-nigh himself. In the entity many a(prenominal) selective in lickations female genitalia be stored.PropertiesProperties miserlys the study or inside developments of an Entity. Attribute may incorporate as severalizeed sorts of value bid numeral, Characters, Integer etc. Simply attributes argon the belongingss of entity.Entity race Diagram ( ERD )An entity- descent diagram is a information mold diagram and technique. ERD cig bette make a graphical re entry of the alliances amidst entities, the entities, and within an information trunk. at that place ar three type relationships in the Entity Rela tionship Diagram ( ERD ) single to unitaryOne to moreMany to ManyThe chief constituents of Entity Relationship Diagram ( ERD )EntityPropertiesRelationshipCardinalityEntitiesDe parcelment competent AreaStaffPlan mental energy school-age childRegistrationExaminationConsequenceCourse bunk attendingAdvancementEntities with PropertiesDepartmentDepartment_ID ( PK )Department_NameDepartment_DetailsDepartment_Leader schoolSubject_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_TypeStudent_ID ( FK )Program_ID ( FK )StudentStudent_ID ( PK )Student_NameStudent_TypeStudent_DetailsStude nt_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 lend-upIn my ERD plot just round(prenominal) relation translation are pre spunkption in the beneathIn the Entity Relationship Diagram I find come out of the closet the relation amongst section and capable landed estate is nonpareil to many, because whizz section may hold many capable countries.In the scenario I crowd out live one capable boorish may hold more thinks.In the ERD diagram the relationship between aim and readiness is one to many. Many fa culties are under of a intention. Module is use a exotic profound of pictures.In the ERD diagram the relationship between pupils and faculties are one to many, because one pupil may hold more than one faculty. In the relationship pupil master(a) key is used as a foreign key in the faculty entity.In the ERD diagram the relationship between pupil and test is one to many. One pupil may concur part more tests.In the ERD diagram the relationship between pupil and coursework is one to many. One pupil may take part in the more coursework.In the ERD diagram the relationship between adjustment and pupil is one to many. The enrollment may be registers for more pupils at same clip.In the ERD diagram re eithery I see the one to many dealingss. For this ground I include one to many relationships in the ERD diagram. In the existent life for database one to many relationship is consummate(a) to me.DrumheadIn this set about I draw an entity relationship diagram. To describe the diagram I find out some entities and properties of entities. To make this toil I at any rate learn about entities, properties and entity relationship diagram.Task-02IntroductionIt is said to dominionise in the working class 2. For doing a database successfully Normalization moldiness be needed. The activities of a database count on vantage pointardisation. Standardization helps to do a database rebelliously. In the undertaking I will adjudicate to normalise for a section strategy in the institution. The standardisation occurs in some stairss. In the undermentioned stairss are given.DescriptionStandardizationIn the organisation alone activities now depend on the computing political machine form. roughly corporate organisation need database dodge for tyrannical all information. As a essence database is most popular and indispensable things in the universe. For doing a database successfully normalization is the traditional trend. 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 emotional state. The intent of standardization is divided into two parts. Removing unneeded informations and guaranting informations habituations. If same informations stay in some tabular array together the database may victim. Often it may data in the unrelated tabular array. To work out these jobs we can be done standardization. The intents of standardization are worthy to diminish the sum of infinite a database consumes and guarantee that information is logically stored. The public placeation of database direction system depends on the standardization.Some stairss are indispensable for standardization. The stairss are given briefly in the followersGathering informationsGathering informations is the first mensurate of standardization. When I normalize I will roll up all information in the phase. I will implement all infor mations of this pulsation in the following measure.Choosing a keyFor making standardization a key is indispensable. The key is the chief informations for standardization. All informations depend on the key. The key must be one from garnering informations.First Normal model ( 1NF )Some functions have to follow in the stairss. Repeating informations in the standardization, sometime it may harmful for standardization, so it required to take reiterating informations in the standardization. Removing reiterating informations is the chief work in this undertaking. imprimatur Normal Form ( 2NF )Second normal signifier ( 2NF ) is used to different and take same informations in the database. The phase alike provides farther information for taking same informations in the database. The chief activities of the phaseThe all informations of first normal signifier must be represented in the phase.Same information in the rows of database tabular array are removed in the phase.The relationship of modern tabular array is make in the phase.Third Normal Form ( 3NF )In the 3rd normal signifier some activities are occurred. The undermentioned activities are given in the belowAll demands of the second normal signifier are present in the phase.The activities of the phase is removed 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 puzzle forth the self-coloured standardization by become forthing a standardization diagram. The standardization diagram is symbol of a better database. If standardization tabular array is clear, informations base become clear.Gathering DatasDepartment_IDDepartment_NameDepartment_DetailsDepartment_Leaderequal to(p) Area_IDCapable Area_LeaderCapable Area_NameCapable Area_Detailsemployee_IDemployee_Leaderemplo yee _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 Normal Form ( gain to reiterating informations )Student ( Repeating ) Department_idDepartment_ nameStudent_idStudent_nameStudent_emailStudent_ forebodeStudent_address plain of exploits_modeEmployee_idEmployee_nameEmployee_phoneEmployee_emailEmployee_addressesSexual activityProgram_idProgram_nameProgram_timeCredit_idTotal_cour se_marksTotal_module_marksTotal_creditConsequenceModule_idModule_nameModule_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 mannerProgram Idaho ( fk )Programe namePlan leaderRecognitionRecognition Idaho ( pk )Student Idaho ( fk )Entire coursework kindExam gradeModule gradeEntire scholarshipConsequenceFacultyModule Idaho ( pkModule leaderFaculty namePrograme Idaho ( fk )Programe nameEmployeeEmployee Idaho ( pk )Employee nameEmployee electronic mailEmployee phoneEmployee referenceSexual activityDepatment Idaho ( fk )Department nameDepartmentDepartment Idaho ( pk )Department namePlanProgram Idaho ( pk )Capable acres 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_creditConsequenceOptimization abstractIn the undertaking I normalized for a section. I normalize for safekeeping database direction system. To make this undertaking I analyzed about standardization. I think I normalized good. Clear stand ardization helps to do a better database direction system. I learned more about standardization to make this undertaking.Undertaking 3IntroductionThe undertaking 3 contains some capacitys. Database commission System ( database allotment system ) is component of the undertaking. I will make a database by utilizing Database Management System ( DBMS ) . in that location are some ways to do database. But 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 marginal 5 records.DescriptionSome stairss I followed to make this undertaking. The stairss and demands are given in the belowDatabase Management System ( DBMS ) To pull rack up a database some strong functions are followed. Database direction system is a sort of environment where all sorts functions and ordinance are included. A database direction system ( DBMS ) works as a database director. Database Management System ( DBMS ) is computing machine image or package. The package helps others computing machine users create and entree informations in a database. Anyone can entree the information, where information is located it is non fact, It manages user petitions so that users and other plans are free from attribute 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 secure database. Database direction system s environment helps to do a good relationship in the database.The activities for this undertaking are followingMY databaseGenerated Script from Generate SQL Server Scripts sense datum SET ANSI_NULLS ON journeySET QUOTED_IDENTIFIER ON run lowIF not EXISTS ( train * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . sect ion ) AND type in ( NU ) ) drag set down render TABLE dbo . section ( department_id nchar ( 10 ) not NULL, department_name nvarchar ( 50 ) NULL, reserve PK_department aboriginal keystone CLUSTERED( department_id ASC) WITH ( IGNORE_DUP_ happen upon = murder ) ON basal ) ON special end up tourSET ANSI_NULLS ON lastSET QUOTED_IDENTIFIER ON moveIF non EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . employee ) AND type in ( NU ) ) own down pee-pee TABLE dbo . employee ( employee_id nchar ( 10 ) non 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 nvarchar ( 1 ) NULL, chasteness PK_employee direct rouge CLUSTERED( employee_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON immemorial ) ON PRIMARY fetch upTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF not EXISTS ( S ELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . subjectarea ) AND type in ( NU ) ) induct downCREATE TABLE 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, timidity PK_subjectarea PRIMARY KEY CLUSTERED( subjectarea_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . plan ) AND type in ( NU ) )Get downCREATE TABLE 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, shyness PK_program PRIMARY KEY CLUSTERED( program_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravel SET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . faculty ) AND type in ( NU ) )Get downCREATE TABLE 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, diffidence 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 ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . pupil ) AND type in ( NU ) )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 ( 100 ) NULL, program_id nchar ( 10 ) NULL, StudyMode nchar ( 10 ) NULL,CONSTRAINT PK_student PRIMARY KEY CLUSTERED( studen t_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( SELECT * 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 ( SELECT * FROM sys.objects WHERE object_id = OBJECT_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, consequence 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 ) )ALTER TABLE dbo . employee WITH CHECK attention deficit disorder CONSTRAINT FK_employee_department alien 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 = OBJECT_ID ( N dbo . subjectarea ) )ALTER TABLE dbo . subjectarea WITH CHECK ADD CONSTRAINT FK_subjectarea_department distant 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 ) )ALTER TABLE dbo . subjectarea WITH CHECK ADD CONSTRAINT FK_subjectarea_employee outside 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 ) )ALTER TABLE dbo . plan WITH CHECK ADD CONSTRAINT FK_program_employee international 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 ADD CONSTRAINT FK_program_subjectarea overseas 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_employ ee ) AND parent_object_id = OBJECT_ID ( N dbo . faculty ) )ALTER TABLE dbo . faculty WITH CHECK ADD CONSTRAINT FK_module_employee unconnected 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 alien 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 d bo . 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 forth the diagram of database. I included all table mean five records. To make the undertaking absolutely I march all tabular arraies screen shot with records.Undertaking 4IntroductionThe chief activities are said in the undertaking. In the undertaking I will quire of my database. Now in the undertaking I will seek to implement. I will verify the operation of database. I will quire of the database harmonizing the outlook 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 un dertaking. 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 midland pithdbo.subjectarea ON dbo.employee.employee_id = dbo.subjectarea.subjectarea_leaderEnd crossingPLs along with the name ( s ) of the capable countryQuerieSELECT dbo.program.program_leader, dbo.employee.employee_id, dbo.program.program_nameFROM dbo.employee versed JOINdbo.program ON dbo.employee.employee_id = dbo.program.program_leaderEnd harvest-tideMLs along with the name ( s ) of the capable countrySELECT dbo.module.module_leader, dbo.employee.employee_name, dbo.module.module_nameFROM dbo.employee INNER JOINdbo.module ON dbo.employee.employee_id = dbo.module.module_leader2. tell on the undermentioned information for the Artificial Intelligence capable countrya ) The list 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 INNER JOINdbo.module ON dbo.program.program_id = dbo.module.program_idWHERE ( dbo.program.subjectarea_id = sa-03 ) full point Celsius ) The list of pupils who have awarded a Pass for one of the facultiesQuerieSELECT obvious C.student_id, student.student_name, C.module_id, module.module_name, C.resultFROM recognition AS C INNER JOINfaculty ON C.module_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.subjectarea_id = sa-01 )End productB ) The faculties they study 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.stu dent.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.student.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 assignment. I blameless the undertaking really carefully. As a proven I show some screen shooting of quires. I besides show SQL quires in the assignment.Undertaking 5Introduction There are five undertakings in the assignment. Each undertaking is made for a specific and different subject. Such a undertaking is confinement 5. In the undertaking 5 I will seek to stand for a study for unit of measurement assignment. The study will incorporate the description 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 DevelopmentRecipient- Mrs Jesmin AktarAuthor- Shanta MariaIntroduction of my premiseThe rubric of the assignment is College Database Development. The college take a computerized system for keeping the activities of a section. To keeping the section activities the college necessarily an ideal database direction system. To complete these activities of this assignment I mentioned each subject for the assignment in the separately. I think I learned m ore things as pupil, to make this assignment. After completing each undertaking responsibility I will bring forth a study for take care my accomplishment on my depth psychology, design and thought accomplishment.Overview of whole assignmentThe sum-up of the whole assignment, I want 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 designation of entity.PropertiesAttributes refers the inside informations information of an Entity. There are many types are fixed for property. These values 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. E ntity 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 demonstration of database direction system depends on the standardization.Some stairss are indispen sable 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. Making 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 database. To make SQL quires in the undertaking I learned more things about SQL bid and other secure information of SQL waiter.Footings of mentionThe scope for investigated system is extended. All the inside informations about the system hold given. The modern system and the new system image are clear in the scenario. Anyone can see and compare 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 process in many ways. In the assignment I followed the operation and practically system of college and others pull offing activities. The chief process and method of the assignment is to settle the current system jobs and besides to present an ideal 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 happen 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 ( admit all hardware )Network 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 information 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 ideal premise about the whole assignment.