Inmt 342 - Study guides, Class notes & Summaries

INMT 342 Exam Set Questions and Answers (Graded A)

INMT 342 Exam 3 Questions and Answers

INMT 342 Exam Set Questions and Correct Solutions physical database design purpose - CORRECT ANSWER-translate the logical description into technical specifications for storing & retrieving data physical database design goal - CORRECT ANSWER-create a design for storing data that will provide: - performance - data integrity - data security - data recoverability - simplify application development physical design process inputs - CORRECT ANSWER-- normalized relations - volume estimate...

INMT 342 Exam 3 Questions and Answers Latest what is the purpose of physical db design? - CORRECT ANSWER-translate the logical description into technical specifications for storing and retrieving data what is the goal of physical db design? - CORRECT ANSWER-create a design for storing data that will provide: •Performance •Data Integrity •Data Security •Data Recoverability •Simplify Application Development inputs of physical design process - CORRECT ANSWER-•Normalized re...

INMT 342 Exam Questions and Answers In big data, differences in the type/sources of data (structured, unstructured, or semi structured) are referred to as: - Answer-Variety Which of the following would be suitable as a primary key in a database for a table representing a customer? - Answer-Customer ID Which of the following is considered the point of purchase in the procure to pay business process? - Answer-Receive and Inspect Goods Procure to pay - Answer-Buying things Order to ca...

INMT 342 Final Exam with correct Answers

INMT 342 Final Questions with Answers What is middleware and what purpose does it serve - Answer-Middleware expands on the abilities of an operating system. Middleware connects User interfaces with back end data How do you set up ODBC connections - Answer-to create: click on windows icon, click Windows Administrator Tools, ODBS 64Bit, System DSN tab, Add, Choose relevant back end system, Name your new ODBC, put in your authorization to link: On DBMS system, click get external data, ODBC ...

INMT 342 Exam 1 Questions with correct Answers

INMT 342 Exam 1 Certification Questions and Answers 2024/2025 file processing system - CORRECT ANSWER-systems used to store data in different files that are accessed by applications ex: C Traditional File Processing - CORRECT ANSWER-Data was stored in independent files without regard to other needs for that data Advantages: simple to understand, fast processing time, existing infrastructure Disadvantages: Program-data dependence, duplication of data, limited data sharing, excessive ...

INMT 342 Exam 1 Questions and Answers Advantages of traditional file processing - Answer-Simple to understand Fast processing times Existing infrastructure Disadvantages of traditional file processing - Answer-Program-Data dependence Duplication of data Limited data sharing Lengthy development times Excessive program maintenance Advantages of database processing - Answer-Program-Data independence Improved data sharing Planned data redundancy Improved data integrity Faster appli...