Entity Relationship Diagram Analysis

In this job I have to roll up several(prenominal) entity, so an entity attributes and at last ERD.I think I will larn more intimately entity, attributes, Entity kin plat to make this labor.DescriptionEntityAn Entity is an object or existent thing such as a tabular array or signifier. An Entity contains whatever culture about himself. In the entity most informations can be stored.PropertiesProperties means the information or inside informations of an Entity. Attribute may incorporate assorted sorts of value like numeral, Characters, Integer etc. Simply attributes argon the belongingss of entity.Entity Relationship Diagram ( ERD )An entity- kinship diagram is a information mold diagram and technique. ERD can make a graphical representation of the races between entities, the entities, and deep down an information schema. in that location ar three type relationships in the Entity Relationship Diagram ( ERD ) ace to OneOne to ManyMany to ManyThe chief constituents of Entity Relationship Diagram ( ERD )EntityPropertiesRelationshipCardinalityEntitiesDepartmentCapable AreaStaff architectural planFacultyStudentRegistrationExaminationConsequenceCourseworkAttendanceAdvancementEntities with PropertiesDepartmentDepartment_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 ) be afterProgram_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_DetailsStudent_AddressModule_ID ( FK )Registration_ID ( FK )ExaminationExam_ID ( PK )Exam_DetailsExam_NameExam_Dat eExam_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 some relation comment are given in the belowIn the Entity Relationship Diagram I find out the relation between section and capable inelegant is unitary to many, because wizard section may hold many capable countries.In the scenario I can see wizard capable boorish may hold more plans.In the ERD diagram the relationship between plan and dexterity is one to many. Many faculties are under of a plan. Module is utilize a foreign key of plans.In the ERD diagram the relationship between scholarly persons and faculties are one to many, because o ne pupil may hold more than one faculty. In the relationship pupil primary 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 take 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 enrollment and pupil is one to many. The enrollment may be registers for more pupils at same clip.In the ERD diagram sincerely 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 perfect to me.DrumheadIn this trade union movement I draw an entity relationship diagram. To pull the diagram I find out some entities and properties of entities. To make this labor movement I at any rate learn about entities, properties and entity relationship diagram.Task-02IntroductionIt is said to change in the undertaking 2. For doing a database successfully Normalization must be needed. The activities of a database depend on standardisation. standardisation helps to do a database rebelliously. In the undertaking I will seek to normalise for a section placement in the memorial tablet. The standardisation occurs in some stairss. In the undermentioned stairss are given.DescriptionStandardizationIn the organisation all activities now depend on the computing machine system. Some corporate organisation need database system for commanding all information. As a consequence database is most popular and inborn things in the universe. For doing a database successfully standardization is the traditional port. Without standardization it is impossible to do a database. Standardization is the social function is used to form the informations absolutely in a database. I normalize the section information for some specific intent. The intent of standardization is divided i nto twain parts. Removing unneeded informations and guaranting informations dependences. 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 creditable to diminish the sum of infinite a database consumes and guarantee that information is logically stored. The public presentation of database armorial bearing system depends on the standardization.Some stairss are indispensable for standardization. The stairss are given briefly in the followersGathering informationsGathering informations is the source flier of standardization. When I normalize I will roll up all information in the phase. I will implement all informations of this measure 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 work ( 1NF )Some functions have to follow in the stairss. Repeating informations in the standardization, sometime it may harmful for standardization, so it necessary to take reiterating informations in the standardization. Removing reiterating informations is the chief work in this undertaking. foster Normal Form ( 2NF )Second normal signifier ( 2NF ) is used to different and take same informations in the database. The phase besides provides far 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(p) information in the rows of database tabular array are removed in the phase.The relationship of new tabular array is made 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 2nd normal signi fier 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 bring out the whole standardization by bring 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_LeaderCapable Area_IDCapable Area_LeaderCapable Area_NameCapable Area_Detailsemployee_IDemployee_Leaderemployee _Typeemploye _Nameemployee_JoiningDateStaff_AddressProgramme_IDProgramme_LeaderProgramme_NameProgramme_TypeProgramme_DetailsStudent_IDRegistration_IDRegistration_DateRegistration_TypeModule_IDModule_NameModule_LeaderModule_Descriptio nModule-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 ( consider to reiterating informations )Student ( Repeating ) Department_idDepartment_nameStudent_idStudent_nameStudent_emailStudent_phoneStudent_addressStudy_modeEmployee_idEmployee_nameEmployee_phoneEmployee_emailEmployee_addressesSexual activityProgram_idProgram_nameProgram_timeCredit_idTotal_course_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 gradeExam 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 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 )Employe e_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 holding database direction system. To make this undertaking I canvas about standardization. I think I normalized good. Clear standardization helps to do a better database direction system. I learned more about standardization to make this undertaking.Undertaking 3IntroductionThe undertaking 3 contains some subjects. Database Management arrangement ( database management system ) is com ponent of the undertaking. I will make a database by utilizing Database Management System ( DBMS ) . There are some ways to do database. But I will make database in the SQL server, 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 System ( DBMS ) To pull off 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 plan or package. The package helps others computing machine users create and entree informations in a database. Anyone can entree the information, where information is placed it is non fact, It manages user petitions so that users and other plan s 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 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 Wizard restrict ANSI_NULLS ON transitSET QUOTED_IDENTIFIER ONTravelIF non EXISTS ( give * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . section ) AND type in ( NU ) ) push down shape display panel dbo . section ( department_id nchar ( 10 ) not NULL, department_name nvarchar ( 50 ) NULL, chasteness PK_department primary get a line CLUSTERED( department_id ASC) WITH ( IGNORE_DUP_KEY = glum ) ON ori ginal ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF not EXISTS ( distribute * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . employee ) AND type in ( NU ) )Get downCREATE TABLE 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 nvarchar ( 1 ) NULL,CONSTRAINT PK_employee PRIMARY KEY CLUSTERED( employee_id ASC) WITH ( IGNORE_DUP_KEY = glowering ) ON PRIMARY ) ON PRIMARY EndTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF NOT EXISTS ( pack * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . subjectarea ) AND type in ( NU ) )Get downCREATE TABLE dbo . subjectarea ( subjectarea_id nchar ( 10 ) NOT NULL, subjectarea_name nvarchar ( 50 ) NULL, department_id nchar ( 10 ) NOT NULL, subjectarea_leader n char ( 10 ) NOT NULL,CONSTRAINT 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,CONSTRAINT 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 ( 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, mo dule_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 ( 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( student_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_modul e ( 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 . apprehension ) 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 . empl oyee ) )ALTER TABLE dbo . employee WITH CHECK ADD CONSTRAINT FK_employee_department FOREIGN 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 FOREIGN 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 FOREIGN 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 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 ADD 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_p rogram ) 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_m odule_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 forth the diagram of database. I included all table mean five records. To make the undertaking absolutely I argue 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 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 home(a) JOINdbo.subjectarea ON dbo.employee.employee_id = dbo.subjectarea.su bjectarea_leaderEnd productPLs along with the name ( s ) of the capable countryQuerieSELECT dbo.program.program_leader, dbo.employee.employee_id, dbo.program.program_nameFROM dbo.employee inner(a) JOINdbo.program ON dbo.employee.employee_id = dbo.program.program_leaderEnd productMLs 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. demonstrate the undermentioned information for the conventionalized 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 )degree Celsius ) The list of pupils who have awarded a Pass for one of the facultiesQuerieSELECT DISTINCT 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 persuasion 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 I NNER 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.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.modu le_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 appellative. I finished the undertaking really carefully. As a proven I show some screen shooting 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 study for whole assignment. The study will incorporate the interpretation of my system design for a section of an organisation. In this stu dy 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 needs a computerized system for keeping the activities of a section. To keeping the section activities the college needs 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 more things as pupil, to make this assignment. After completing each undertaking right I will bring forth a study for discover my accomplishment on my analysis, 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. 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 informat ion. 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. Making database was the function of the undertaking. As a cons equence 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 current 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 dramatics 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 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 )Network ConnectionSQL waiterWindows XP.NET modelFu ture 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 seek to supply an ideal premise about the whole assignment.