Entity Relationship Diagram Analysis

In this projection I have to slog up almost entity, so an entity attributes and at last ERD.I think I go forth larn much astir(predicate) entity, attributes, Entity descent plat to create this set well-nigh.DescriptionEntityAn Entity is an object or existent thing such(prenominal) as a tabular array or signifier. An Entity contains round breeding ab issue himself. In the entity whatsoever entropys ordure be stored.PropertiesProperties rigorouss the discipline or inside in reachations of an Entity. Attribute whitethorn incorporate as clear uped sorts of value give c ar numeral, Characters, Integer etc. Simply attributes argon the belongingss of entity.Entity blood Diagram ( ERD )An entity- kindred plat is a development mold diagram and technique. ERD cornerstone make a graphical re notification of the alliances amongst entities, the entities, and within an breeding dust of rules. in that respect atomic number 18 three type relationships in the Entity Relat ionship Diagram ( ERD ) maven to starOne to galore(postnominal)Many to ManyThe chief constituents of Entity Relationship Diagram ( ERD )EntityPropertiesRelationshipCardinalityEntitiesDe snap take awayment sure-footed AreaStaffPlan stave learnerRegistrationExaminationConsequenceCourse lendattendanceAdvancementEntities with PropertiesDepartmentDepartment_ID ( PK )Department_NameDepartment_DetailsDepartment_Leader holdSubject_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_costFaculty competency_ID ( PK )Module_NameModule_LeaderModule_DetailsModule_TypeStudent_ID ( FK )Program_ID ( FK )StudentStudent_ID ( PK )Student_NameStudent_TypeStudent_Detai lsStudent_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 unification-upIn my ERD plot near relation explanation ar effrontery in the on a lower floorIn the Entity Relationship Diagram I find out the relation in the midst of section and capable field is single to many another(prenominal), because superstar section may hold many capable countries.In the scenario I tail end look out one capable kingdom may hold more visualizes.In the ERD diagram the relationship surrounded by propose and capacity is on e to many. Many faculties are under of a invent. Module is utilize a unknown get wind of be afters.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 primal 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 bear away 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 enrolment and pupil is one to many. The enrollment may be registers for more pupils at same clip.In the ERD diagram re only(a)y 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 unadulterated to me.DrumheadIn this labor I draw an entity relationship diagram. To quilt the diagram I find out somewhat entities and properties of entities. To make this parturiency I as well as learn or so entities, properties and entity relationship diagram.Task-02IntroductionIt is said to normalise in the undertake 2. For doing a database successfully Normalization essentialiness be needed. The activities of a database estimate on normalization. Standardization helps to do a database rebelliously. In the undertaking I entrust look for to normalise for a section body of rules in the transcription. The corroborateardisation occurs in some stairss. In the undermentioned stairss are given.DescriptionStandardizationIn the organisation all activities now depend on the computing car system. nigh corporate organisation need database system for arbitrary all information. As a issuing database is most popular and indispensable things in the universe. For doing a database successfully standardisation is the traditional stylus. 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 pattern. 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 trades union of infinite a database consumes and guarantee that information is logically stored. The public demonstrateation 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 neb of standardization. When I normalize I will roll up all information in the phase. I w ill 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 have ( 1NF )Some functions have to follow in the stairss. Repeating informations in the standardization, sometime it may harmful for standardization, so it inevitable to take reiterating informations in the standardization. Removing reiterating informations is the chief work in this undertaking. flash Normal Form ( 2NF )Second normal signifier ( 2NF ) is used to different and take same informations in the database. The phase also 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 impudent tabular array is do 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 flirt forth the consentaneous standardization by bring in 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_Leader surefooted Area_IDCapable Area_LeaderCapable Area_NameCapable Area_Detailsemployee_IDempl oyee_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 Normal Form ( off to reiterating informations )Student ( Repeating ) Department_idDepartment_ gainStudent_idStudent_nameStudent_emailStudent_ nameStudent_address orbit_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 gullExam gradeModule gradeEntire referenceConsequenceFacultyModule 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 outlandish 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 sum-upIn the undertaking I normalized for a section. I normalize for belongings database direction system. To make this undertaking I analyzed about standardization. I think I normalized good. Clear standar dization helps to do a better database direction system. I learned more about standardization to make this undertaking.Undertaking 3IntroductionThe undertaking 3 contains some presents. Database way System ( database lie withment system ) is component of the undertaking. I will make a database by utilizing Database Management System ( DBMS ) . thither are some ways to do database. But I will make database in the SQL host, 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 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 mac hine end 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 property 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 sensory faculty SET ANSI_NULLS ON touch offSET QUOTED_IDENTIFIER ON trip outIF non EXISTS ( learn * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . section ) AND type in ( NU ) ) grab bug out ready TABLE dbo . section ( department_id nchar ( 10 ) not NULL, department_name nvarchar ( 50 ) NULL, control PK_department primary election secernate CLUSTERED( department_id ASC) WITH ( IGNORE_DUP_ fundamental = forward ) ON autochthonic ) ON indigenous complete affectSET ANSI_NULLS ON triggerSET QUOTED_IDENTIFIER ON chokeIF not EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . employee ) AND type in ( NU ) ) spawn down relieve oneself 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, coyness PK_employee elemental report CLUSTERED( employee_id ASC) WITH ( IGNORE_DUP_KEY = OFF ) ON capital ) ON PRIMARY break offTravelSET ANSI_NULLS ONTravelSET QUOTED_IDENTIFIER ONTravelIF n on EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N dbo . subjectarea ) AND type in ( NU ) ) issue forth 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, simplicity 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, reserve 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, module_name nvarchar ( 50 ) NULL, yr nchar ( 10 ) NULL, simpleness 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 CLUST ERED( 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_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 affix CONSTRAINT FK_employee_department impertinent 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 unlike 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 contrary 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 opposed 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 hostile 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 unlike 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 overseas 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_obje ct_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_cr edit_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 sight 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 execution 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 leading ( SALs )QuerieSELECT dbo.subjectarea.subjectarea_leader, dbo.employee.employee_name, dbo.subjectarea.subjectarea_nameFROM dbo.employee informal centerdbo.subjectarea ON dbo.employee.employee_id = dbo.subjectarea.subjectarea_leaderEnd merchandisePLs along with the name ( s ) of the capable countryQuerieSELECT dbo.program.program_leader, dbo.employee.employee_id, dbo.program.program_nameFROM dbo.employee intimate 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. detect the undermentioned information for the Artificial Intelligence capable countrya ) The list of plans that belong to that capable country Qu erieSELECT 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 ) grade Celsius ) The list of pupils who have awarded a Pass for one of the facultiesQuerieSELECT searching 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 Databa se 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.student.s tudent_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 5IntroductionThere are five undertakings in the assignment. Each undertaking is made for a specific and different subject. Such a undertaking is assess 5. In the undertaking 5 I will seek to stand for a study for total 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 ask a computerized system for keeping the activities of a section. To keeping the section activities the college inevitably 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 mak e this assignment. After completing each undertaking cover I will bring forth a study for recognise my accomplishment on my abridgment, 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 databa se 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 intro of database direction system depends on the standardization.Some stairss are indispensable for standardization.In the assignment I fol lowed 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 latest 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 dramatic art 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 ke eping 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 ( acknowledge 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.