Primary key Foreign keys Normalization Referential Integrity SQL 5 10 21 What

Primary key foreign keys normalization referential

This preview shows page 1 - 2 out of 2 pages.

What is a relational database? Primary key? Foreign keys? Normalization? Referential Integrity? SQL (#5, #10, #21) What are relationships? Types of relationships with exampled- one to one (1:1), one to many(1:M), many to many (M:N) Database Management System (DBMS)-its purpose, its functions (#15, #16, #19) What is a non-relational (NoSQL) database? Examples of its use. (#23) What is Big Data & its characteristics (#25) Business Intelligence Infrastructure is tools for obtaining useful information from internal and external systems and big data (#27, #32) What is a Data Warehouse? Data mart? (#28) Once data is gathered, tools are required for consolidating, analysing, to use insights to improve decision making. These tools can be reactive or proactive. What are these tolls and their differences? (#33) How can we ensure data quality? What are the characteristics of high quality data? (#41, #42) Chapter 7 (some important terms are in bold) Important terms: Convergence (unified communications), Voice over IP (VoIP), Virtual private network (VPN) tunneling #28, URL What is a computer network & its major components-server with NOS, switch, router (#4, #5) Other components needed to support a corporation: Wired & wireless LAN, Intranet, Extranet, video conferencing Client server computing is dominant type of networking & the Internet is largest implementation of client/server computing (#8) The Internet uses Packet Switching (#9, #10) and the Protocol TCP/IP (#11), What is a protocol? What is Telecommunication ? What is the difference between an analog and digital signal ? What is a modem & why is it needed? (#13, #14) Types of network differ based on the area or distance covered. Ranging from LANs to WANs. (#14, Table 7.1) Transmission of the message (signal) can be wired or wireless— transmission media . What are the major transmission media, what is transmitted (electricity or light)? Each media has a maximum t ransaction capacity (measured in bps) and is dependent on its frequency measured in hertz/cycles per second. The range of frequencies that can be accommodated on a specific communication channel is called bandwidth (See Table 7.2, #15) What is the Internet? How does it provide business value?
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Spring '16
  • Beverly Kahn

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes