Inmt 342 exam set Study guides, Revision notes & Summaries

INMT 342 Exam Set Questions and Answers (Graded A)

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...

physical database design purpose - right answer--translate the logical description into technical specifications for storing & retrieving data physical database design goal - right answer--create a design for storing data that will provide: - performance - data integrity - data security - data recoverability - simplify application development physical design process inputs - right answer--- normalized relations - volume estimates - attribute definitions - response time expectations...

Study Set Exam for INMT 342 1 Questions and Answers What does ERD stand for? - CORRECT ANSWER-Entity-Relationship Diagram What is a table in conceptual modeling? - CORRECT ANSWER-An Entity What is a field in Conceptual Modeling? - CORRECT ANSWER-An attribute What are the two requirements of entities? - CORRECT ANSWER-1) must have many instances 2) must have multiple fields or attributes What are the three types of entities? - CORRECT ANSWER-Strong entity, Weak entity, and associative...

INMT 342 Exam Set physical database design purpose - Answer- translate the logical description into technical specifications for storing & retrieving data physical database design goal - Answer- create a design for storing data that will provide: - performance - data integrity - data security - data recoverability - simplify application development physical design process inputs - Answer- - normalized relations - volume estimates - attribute definitions - response time expectati...

INMT 342 Final Exam Questions and Answers What is middleware and what purpose does it serve - CORRECT 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 - CORRECT 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...