LEARN MORE...

CS 245 IIT Database Management Systems & Rational Algebra PPT

Content type

User Generated

Subject

Computer Science

School

Indian Institute of Technology Guwahati

Course

CS 245

Type

Presentation

Uploaded By

terl_jvaq

Pages

48

Showing Page:

1/48

Sign up to view the full document!

Showing Page:

2/48

Sign up to view the full document!

Showing Page:

3/48

Sign up to view the full document!

End of Preview - Want to read all 48 pages?

Unformatted Attachment Preview

Database Management Systems Vijaya Saradhi IIT Guwahati Fri, 07th Feb 2020 Vijaya Saradhi (IIT Guwahati) CS245 Fri, 07th Feb 2020 1 / 35 Relational Algebra Relational Algebra (RA) Cartesian Product - × Definition Takes two relation as input Produces a new relation that has Number of columns = sum of the individual relations columns A set {(x, y )|x ∈ R y ∈ S} Notation: R × S Example Relation R1 A B 1 2 3 4 B 2 4 9 R1 .A 1 1 1 3 3 3 Relation S1 C D 5 6 7 8 10 11 Vijaya Saradhi (IIT Guwahati) CS245 Relation R1 × S1 R1 .B S1 .B S1 .C 2 2 5 2 4 7 2 9 10 4 2 5 4 4 7 4 9 10 S1 .D 6 8 11 6 8 11 Fri, 07th Feb 2020 2 / 35 Relational Algebra Relational Algebra (RA) Natural Join Definition Cross product ‘joins’ relations without conditions It is compute and memory intense operation Joining relations on a specified criteria Join tuples by attributes that are common to relations in question Join take place when the values are identical among common attributes of the two relations Produces a new relation that has Notation: R o nS Vijaya Saradhi (IIT Guwahati) CS245 Fri, 07th Feb 2020 3 / 35 Relational Algebra Relational Algebra (RA) Natural Join Example Relation R1 A B 1 2 3 4 B 2 4 9 Relation S1 C D 5 6 7 8 10 11 Vijaya Saradhi (IIT Guwahati) Relation R1 n o S1 R1 .A R1 .B S1 .B S1 .C S1 .D 1 2 2 5 6 3 4 4 7 8 one of the columns R1 .B or S1 .B is retained. CS245 Fri, 07th Feb 2020 4 / 35 Relational Algebra Relational Algebra (RA) Thet ...
Purchase document to see full attachment

Tags: Database Management Systems compute and memory intense operation Natural join specified condition

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Studypool

4.7

Indeed

4.5

Sitejabber

4.4

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic math to advanced rocket science!

Post question

Academy of Chinese Culture and Health Sciences SQL Computer Project

Academy of Chinese Culture and Health Sciences SQL Computer Project

CYB 670 Bowling Green State University Protecting Homeland After Action Reports Paper

At the start of this course, you were divided into teams, and each team was assigned to a nation in the Five Eyes intellig ...

CYB 670 Bowling Green State University Protecting Homeland After Action Reports Paper

At the start of this course, you were divided into teams, and each team was assigned to a nation in the Five Eyes intelligence alliance. As a nation team, you collaborated to represent and defend the cybersecurity policy and posture of the nation assigned to you.Your team was also assigned to a critical infrastructure sector, which you will also represent in Project 4. Research for Project 4 is designed to span the entire term, and your team is expected to complete it in parallel with Projects 1 through 3.You will work with your team to prepare for and then complete the Executive Leadership In Tabletop Exercises (ELITE) activity, and then write a report that identifies risks to cyber networks within the critical infrastructure industry segment assigned to your team and proposes recommendations to mitigate risks and make the networks more secure. This project will span across the entire course, but should take about 24 days to complete. After reading the scenario below, proceed to Step 1 where you will establish your team agreement plan.This is the part of the project I will be writing!!!!!!!!!!Upon the conclusion of the second round of events, you have reviewed the results as a team. Now you will collaborate to create the second After Action Report (AAR) and make new decisions based on the new set of events for Round 3. Select decisions in response to the final events in ELITE by following these steps:Begin writing the Round 2 After Action Report in accordance to your team agreement and schedule.When you have completed AAR #2, a designated team member should submit it for feedback. This team member should also post the AAR in the ELITE Industries Sharing Discussion to share with the other sectors.Log in to ELITE to begin round 3.Review the newscasts and advisories for any new events.Meet with your team (and other teams if you have formed a multi-industry council) to review the Round 2 outcomes, reports, and debrief from the CISO. Collaborate on what new decisions need to be made.Make the new decisions in ELITE according to the responsibilities assigned to you in your team's ELITE agreement from a previous step. Because these decisions are tied to your login information, your team members will not be able to change or update these values. Final Round 3 values must be selected by 11:59 p.m. eastern time the day after the ELITE round begins. See your team schedule for details.

referential integrity

definition of referential integrity

referential integrity

definition of referential integrity

Creating a Database Design, computer science homework help

This assignment contains two (2) Sections: Database Design and Design Summary. You must submit both sections as separate f ...

Creating a Database Design, computer science homework help

This assignment contains two (2) Sections: Database Design and Design Summary. You must submit both sections as separate files in order to complete this assignment. If you are using Visio, see “Appendix A: Designing Databases with Visio Professional 2010: A Tutorial” to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A; however, using open source applications or even pen and paper within labs is permitted.)Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:Business Rules and Data Models to complete the lab:Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.Section 1: Database Design Diagram (Using Microsoft Visio is optional; you may also use any other application you know or even draw the diagram with pen and paper and take a picture of it for submission.)Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).Submit your diagram.Section 2: Design Summary (Microsoft Word or equivalent)3. Write a one (1) page paper in which you:Discuss the degree to which you believe your diagram reflects the database design. Section 2 of your assignment must follow these formatting requirements:Submit the design summary as a Microsoft Word file.Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Describe the role of databases and database management systems in managing organizational data and information. Compose conceptual data modeling techniques to capture the information requirements.Use technology and information resources to research issues in database systems.Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using this rubric.

10-1 Lab Subnet - Class C Private Network Assignment

In this chapter, you subnetted a Class C private network into six subnets. In this project, you work with a Class B privat ...

10-1 Lab Subnet - Class C Private Network Assignment

In this chapter, you subnetted a Class C private network into six subnets. In this project, you work with a Class B private network. Complete the steps as follows:Your employer is opening a new location, and the IT director has assigned you the task of calculating the subnet numbers for the new LAN. You’ve determined that you need 50 subnets for the Class B network beginning with the network ID 172.20.0.0. How many host bits will you need to use for network information in the new subnets?After the subnetting is complete, how many unused subnets will be waiting on hold for future expansion, and how many possible hosts can each subnet contain?What is the new subnet mask?Complete the following table:Subnet numberExtended network prefixRange of host addressesBroadcast address1172.20.0.0172.20.0.1 through 172.20.3.2542172.20.4.0through 172.20.7.2543172.20.8.1 through172.20.11.25545…………50What is the CIDR notation for this network?What is the broadcast address of the subnet for the host at 172.20.6.139?Is the host at 172.20.11.250 on the same subnet as the host at 172.20.12.3? How do you know? Using MS Word only, record your answers. Your answer must be a minimum of one page, single spaced, Times Roman 12-point font. Save the file as CP10-1XXX.docx. Substitute your first, middle, and last name initials in place of XXX. Attach and submit the document on Blackboard.

2 pages

Cyber Security Questions

❖ Compare And Contrast The Vulnerability Scanning Tools You Used In The Labs. Are There Scenarios In Which A Scanning To ...

Cyber Security Questions

❖ Compare And Contrast The Vulnerability Scanning Tools You Used In The Labs. Are There Scenarios In Which A Scanning Tool Would Be Advantageous To ...

Similar Documents

University of Sudbury Metasploit Framework and Pro Penetration Testing Discussion

You can find the requirements in the uploaded file, if you need anything text me....

University of the Cumberlands Team Foundation Server Aachitecture Paper

1. Need an assessment for the TFS in 400 words with 4 references and APA format.2. Answer the following question after the...

very very imp please make it very effectively no plagiarism all must be in APA format with 650 works

please make it very effectively and no plagiarism please be on topicmust be minimum of 650 words please write answer in g...

Write a four to five (4-5) page paper about computer interaction

Assignment 3: Direct ManipulationEarly computer systems relied on command line interfaces to perform all actions. Today, t...

NEC Database Auditing and Monitoring & SOX Compliance Framework Essay

Write an essay of at least 500 words discussing how database auditing and monitoring fit within a SOX compliance framework...

National Infrastructure Protection Plan, Phase 4: Final presentation

Case Study: National Infrastructure Protection PlanPhase 1 due in Week 3Phase 2 due in Week 5Phase 3 due in Week 7Phase 4 ...

Discussion Module 13

In the event of a data breach or cyber assault, an incident response plan (IR) is a published, written plan with six separ...

Cyber Resilience

 The need to address security concerns within organizations has become a critical  Cyber resilience has become an im...

Network Management

Uninterrupted business operations are the single most critical element for any organization. Every second an operation is ...

Study help

Our tutors provide high quality explanations & answers.

Post question

Academy of Chinese Culture and Health Sciences SQL Computer Project

Academy of Chinese Culture and Health Sciences SQL Computer Project

CYB 670 Bowling Green State University Protecting Homeland After Action Reports Paper

At the start of this course, you were divided into teams, and each team was assigned to a nation in the Five Eyes intellig ...

CYB 670 Bowling Green State University Protecting Homeland After Action Reports Paper

At the start of this course, you were divided into teams, and each team was assigned to a nation in the Five Eyes intelligence alliance. As a nation team, you collaborated to represent and defend the cybersecurity policy and posture of the nation assigned to you.Your team was also assigned to a critical infrastructure sector, which you will also represent in Project 4. Research for Project 4 is designed to span the entire term, and your team is expected to complete it in parallel with Projects 1 through 3.You will work with your team to prepare for and then complete the Executive Leadership In Tabletop Exercises (ELITE) activity, and then write a report that identifies risks to cyber networks within the critical infrastructure industry segment assigned to your team and proposes recommendations to mitigate risks and make the networks more secure. This project will span across the entire course, but should take about 24 days to complete. After reading the scenario below, proceed to Step 1 where you will establish your team agreement plan.This is the part of the project I will be writing!!!!!!!!!!Upon the conclusion of the second round of events, you have reviewed the results as a team. Now you will collaborate to create the second After Action Report (AAR) and make new decisions based on the new set of events for Round 3. Select decisions in response to the final events in ELITE by following these steps:Begin writing the Round 2 After Action Report in accordance to your team agreement and schedule.When you have completed AAR #2, a designated team member should submit it for feedback. This team member should also post the AAR in the ELITE Industries Sharing Discussion to share with the other sectors.Log in to ELITE to begin round 3.Review the newscasts and advisories for any new events.Meet with your team (and other teams if you have formed a multi-industry council) to review the Round 2 outcomes, reports, and debrief from the CISO. Collaborate on what new decisions need to be made.Make the new decisions in ELITE according to the responsibilities assigned to you in your team's ELITE agreement from a previous step. Because these decisions are tied to your login information, your team members will not be able to change or update these values. Final Round 3 values must be selected by 11:59 p.m. eastern time the day after the ELITE round begins. See your team schedule for details.

referential integrity

definition of referential integrity

referential integrity

definition of referential integrity

Creating a Database Design, computer science homework help

This assignment contains two (2) Sections: Database Design and Design Summary. You must submit both sections as separate f ...

Creating a Database Design, computer science homework help

This assignment contains two (2) Sections: Database Design and Design Summary. You must submit both sections as separate files in order to complete this assignment. If you are using Visio, see “Appendix A: Designing Databases with Visio Professional 2010: A Tutorial” to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A; however, using open source applications or even pen and paper within labs is permitted.)Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:Business Rules and Data Models to complete the lab:Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.Section 1: Database Design Diagram (Using Microsoft Visio is optional; you may also use any other application you know or even draw the diagram with pen and paper and take a picture of it for submission.)Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).Submit your diagram.Section 2: Design Summary (Microsoft Word or equivalent)3. Write a one (1) page paper in which you:Discuss the degree to which you believe your diagram reflects the database design. Section 2 of your assignment must follow these formatting requirements:Submit the design summary as a Microsoft Word file.Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Describe the role of databases and database management systems in managing organizational data and information. Compose conceptual data modeling techniques to capture the information requirements.Use technology and information resources to research issues in database systems.Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using this rubric.

10-1 Lab Subnet - Class C Private Network Assignment

In this chapter, you subnetted a Class C private network into six subnets. In this project, you work with a Class B privat ...

10-1 Lab Subnet - Class C Private Network Assignment

In this chapter, you subnetted a Class C private network into six subnets. In this project, you work with a Class B private network. Complete the steps as follows:Your employer is opening a new location, and the IT director has assigned you the task of calculating the subnet numbers for the new LAN. You’ve determined that you need 50 subnets for the Class B network beginning with the network ID 172.20.0.0. How many host bits will you need to use for network information in the new subnets?After the subnetting is complete, how many unused subnets will be waiting on hold for future expansion, and how many possible hosts can each subnet contain?What is the new subnet mask?Complete the following table:Subnet numberExtended network prefixRange of host addressesBroadcast address1172.20.0.0172.20.0.1 through 172.20.3.2542172.20.4.0through 172.20.7.2543172.20.8.1 through172.20.11.25545…………50What is the CIDR notation for this network?What is the broadcast address of the subnet for the host at 172.20.6.139?Is the host at 172.20.11.250 on the same subnet as the host at 172.20.12.3? How do you know? Using MS Word only, record your answers. Your answer must be a minimum of one page, single spaced, Times Roman 12-point font. Save the file as CP10-1XXX.docx. Substitute your first, middle, and last name initials in place of XXX. Attach and submit the document on Blackboard.

2 pages

Cyber Security Questions

❖ Compare And Contrast The Vulnerability Scanning Tools You Used In The Labs. Are There Scenarios In Which A Scanning To ...

Cyber Security Questions

❖ Compare And Contrast The Vulnerability Scanning Tools You Used In The Labs. Are There Scenarios In Which A Scanning Tool Would Be Advantageous To ...