Normalization in database - Study guides, Revision notes & Summaries

ICT2622 SUMMARISED NOTES 2022/2023 1 Contents Chapter 1: An overview of systems analysis and design ...................................................................................................................... 5 What is an information system? ............................................................................................................................... 5 What is a computer application (app)? .............................................................................

What are tuples and how are they used in databases? a.) A tuple is a collection of sequenced data fields b.) A tuple is one record or data set in a row c.) A tuple is a database field - Answer A tuple is one record or data set in a row What is the best description of a flat file database? a.) Flat file databases are hierarchical in nature. b.) Flat file databases are prevalent today because they provide relational functions. c.) The flat file design is a single table database. - Answer Th...

DBI 202 Exam (Full) | Questions and Answers (Complete Solutions) QN=1 (6803) A ____ is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and being designed, built and populated with data for a specific purpose a. Database b. Database Instance c. Schema d. Schema Instance QN=2 (6801) Choose the most correct statement. a. Database is created and maintained by a DMBS b. All of the others c. Database is a collection of data that is managed b...

A tuple is one record or data set in a row - Answer-What are tuples and how are they used in databases? a.) A tuple is a collection of sequenced data fields b.) A tuple is one record or data set in a row c.) A tuple is a database field The flat file design is a single table database - Answer-What is the best description of a flat file database? a.) Flat file databases are hierarchical in nature. b.) Flat file databases are prevalent today because they provide relational functions. c.) T...

______ is a traditional approach and has established best practices. It is more commonly found in onpremises environments since it was around before cloud platforms. It is a process that involves a lot o data movement, which is something you want to avoid on the cloud if possible due to its resourceintensive nature. - ETL ________ seems similar to ETL at first glance but is better suited to big data scenarios since it leverages the scalability and flexibility of MPP engines like Azure Synapse...

False - Answer A relation describes the structure, content, and access controls of a physical data store or database. True - Answer A relational database management system stores data in tables. false - Answer Every table in a relational database must have a foreign key. true - Answer A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table. false - Answer Relationships in a relational database are usually represe...

WGU C724 Information Systems Management Unit 4 Test A tuple is one record or data set in a row -Answer-What are tuples and how are they used in databases? a.) A tuple is a collection of sequenced data fields b.) A tuple is one record or data set in a row c.) A tuple is a database field The flat file design is a single table database -Answer-What is the best description of a flat file database? a.) Flat file databases are hierarchical in nature. b.) Flat file databases are prevalent tod...

The server limits data connections. What should you use for connectivity when the number of users exceeds the number of connections? A.) Named Pipes B.) Connection Pooling C.) Connection Timeouts D.) Normalization - Answer- B.) Connection Pooling The database administrator will not allow you to write SQL code in your application how do you retrieve data? A.) Call a stored procedure B.) Script a SELECT statement to a file C.) reference an index in the database D.) Query a databas...

In auditing a database environment, an IS auditor will be MOST concerned if the database administrator (DBA) is performing which of the following functions? Select an answer: A. Performing database changes according to change management procedures B. Installing patches or upgrades to the operating system C. Sizing table space and consulting on table join limitations D. Performing backup and recovery procedures :~~ You answered D. The correct answer is B. 2 | P a g e | © copyri...

___ integrate different organizational processes information into a unified system for the entire enterprise - ANSWER B. ERP Just in Time (JIT) is - ANSWER C. a method for producing or delivering a product or service precisely when the customer wants it Monte Carlo Inc. wants to set up a luxury resort in a desert close to Cairo. With an eye on customer needs, it wants to ensure that all its guests can access the Internet from their rooms, the lobby, and the restaurants. Which of the follow...