- Study guides, Class notes & Summaries

CS 6400 Exam 2 Hard question test prep

-

4 pages

Written in 2025/2026

Grade A+

waindigrace87

CS 6400 Bundled Exam Questions WITH CORRECT Answers

-

8 items

STANFORDGRADESS

CS 6400 Chapter 1 UPDATED ACTUAL Questions and CORRECT Answers traditional database applications - CORRECT ANSWER - examples: going to the bank to withdraw funds, accessing a computerized library catalog to look for a book, etc. in these applications, most of the information that is stored and accessed is either textual or numeric big data storage systems, aka NOSQL systems - CORRECT ANSWER created to manage data for social media applications cloud storage - CORRECT ANSWER ...

-

12 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS 6400 Chapter 4 UPDATED ACTUAL Questions and CORRECT Answers local attributes - CORRECT ANSWER - local to a subclass, not part of the superclass How is a subset denoted in EER diagrams? - CORRECT ANSWER the "U" determines the superclass - a "U"; direct ion of What is the "O" symbol with generalization/specialization diagrams - CORRECT ANSWER - Deals with potential overlapping of subtypes from the supertyp

-

6 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS6400-Exam 1 UPDATED ACTUAL Questions and CORRECT Answers DBMS (Database Management System) - CORRECT ANSWER system that enables users to create and maintain a database Meta Data - CORRECT ANSWER - is a computerized - The database definition or descriptive information is also stored by the DBMS in the form of a database catalog or dictionary transaction - CORRECT ANSWER - an executing program or process that includes one or more database accesses, such as reading or updat...

-

17 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS6400 Database Study Set UPDATED Questions and CORRECT Answers Database - CORRECT ANSWER Data - CORRECT ANSWER meaning - a collection of related data - Known facts that can be recorded and that have implicit Universe of Discourse aka miniworld - CORRECT ANSWER word which a database represents Database Management System (DBMS) - CORRECT ANSWER that enables users to create and maintain a database Defining a database - CORRECT ANSWER - some aspect of the real - a...

-

23 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS 6400 Exam 2 UPDATED ACTUAL Questions and CORRECT Answers Entity type ET with single value property - CORRECT ANSWER an attribute Entity type ET with identifying property A - CORRECT ANSWER be an attribute A that is a primary key Entity ET with composite C, made up D and E - CORRECT ANSWER includes D and E, C is lost Relation model is inherently: - CORRECT ANSWER - flat! - relation ET has B as - relation ET there will - Relation only

-

5 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS6400 chapter 1UPDATED ACTUAL Questions and CORRECT Answers OLAP - CORRECT ANSWER control) data - CORRECT ANSWER - online analytical processing (helps with concurrency - known facts universe of discourse - CORRECT ANSWER Defining DBMS - CORRECT ANSWER - represents real world - creating constraints

-

3 pages

Written in 2025/2026

Grade A+

STANFORDGRADESS

CS 6400 EXAM 3 QUESTIONS AND ANSWERS GRADED A+ Spurious tuples - ANSWER -Tuples generated by joining two relations on attributes that are not keys or foreign keys on these relations. Waste of storage space - ANSWER -due to NULLs and the difficulty of performing selections, aggregation operations, and joins due to NULL values A functional dependency (A->B) - ANSWER -occurs when the attribute A uniquely determines B. A = left-hand side, B=right-hand side. -is a property of the ...

-

31 pages

Written in 2024/2025

Grade A+

TheExamMaestro

Cs 6400 Exam 3 Latest Update Questions And Answers Cs 6400 Exam 3 Latest Update Questions And Answers Cs 6400 Exam 3 Latest Update Questions And Answers

-

35 pages

Written in 2024/2025

Grade A+

AtiExitseller

CS 6400 Bundled Exam Questions and Correct Answers Already Passed

-

2 items

TutorJosh

CS 6400 Exam 2 Questions and Correct Answers Latest Update 2024 Entity type ET with single value property - Answers relation ET has B as an attribute Entity type ET with identifying property A - Answers relation ET there will be an attribute A that is a primary key Entity ET with composite C, made up D and E - Answers Relation only includes D and E, C is lost Relation model is inherently: - Answers flat! Entity ET with identifying property A and multi-value property F - Answers For each F a...

-

3 pages

Written in 2024/2025

Grade A+

TutorJosh

CS 6400 Exam 4 Questions with Correct Answers New Version (Rated 100%) Functional Dependencies - Answers Let X and Y be sets of attributes in R. Y is functionally dependent on X in R iff for each x in RX, there is precisely one y in RY. _________ determines _______ X --> Y Email --> BirthYear, CurrentCity, Salary Questions to ask about normalization - Answers Is this relation laid out in such a manner that it is easy to enforce the functional dependencies that we want to enforc...

-

10 pages

Written in 2024/2025

Grade A+

TutorJosh