Identify two tables for use in your DBMS and assign physical and conceptual names to your tables.
Identify two tables for use in your DBMS and assign physical and conceptual names to your tables.
July 29, 2020 Comments Off on Identify two tables for use in your DBMS and assign physical and conceptual names to your tables. Uncategorized Assignment-help(Nursing Informatics)To identify the data elements you need for a database, you first need to understand the purpose of your DBMS. Based on this, you must examine the following sources of information: Information from users and experts Research literature Existing reports and questionnairesFrom these sources, you will be able to list unique pieces of information (data elements) that will become fields within your database tables. Once you have listed the data elements, you will start to cluster these into primary tables, which will have both a physical and conceptual name.In Week 1, you reviewed the systems that nurses are currently using to manage patient care and nursing processes. In Week 2, you identified a need and purpose for a database that is related to a nursing indicator or patient outcomes. In Week 3, you will construct tables for your DBMS and create data elements by identifying the attributes of your table.Complete the following: See attach document titled Week 3: Assignment 2—DBMS Tables and Data Elements. This document includes the following: Instructions for this assignment A table for completing information on your tables and data elements. Follow the instructions in the above document to address the following: Identify two tables with ten data elements in each table for the DBMS you identified in W2: Assignment 2. Identify two tables for use in your DBMS and assign physical and conceptual names to your tables. Ascertain one data element in each table as a unique identifier, which will become the primary key for the table. Characterize the table by identifying nine data elements that represent the attributes of the table.


