Itda1001 Database Fundamentals-Database Security Answers Assessment Answers
- Explain in your own words how the following piece together in a database: table, field, record, attribute, coloumn, row, data type, entity, table relationship, Autonumber, primary key, foreign key
- Which of the following can be used to insert new records into a database: table design view, table datasheet view, reports, macros, queries, forms
- Which of the following can be used to alter the structure of tables in a database: table design view, table datasheet view, a report, a query, a form
- Describe 2 examples how a Form can be used to improve the speed of a secretary's data entry
- Explain how a Form can be used to improve database security
- Database software:
- Who owns/creates MS Access
- Name another DBMS that this company creates and sells to larger companies
- What is the name of the database programming language that is at the core of all popular database software and what are the names of the “flavours” of that language found in MS Access and MS Server.
Answer:
- The subject is very informative and I am learning a lot of new things which are very informative. The teacher is delivering the content comprehensively thus everything is understandable.
- Table- A table is a collection of attributes or field.
- Field – a field is an attribute in a table holding specific type of data. For example a filed called -first name holding first name of every record.
- Attribute- An attribute is a property that defines an entity.
- A column- a column is a collection of n-tuples of a specific filed in a table.
- A row- a row is a collection of records in a table.
- Data type- A data type specifies the type of data allowed in a field of a table.
- Table relationship- A table relationship is link between two tables through a foreign key.
- Auto number- An auto number is a property of a field where the filed increments by 1 for every record.
- Primary key- The primary key is the unique attribute or filed in a table.
- A foreign key- This is an attribute or field using to create a relationship between two tables
- The following can be used to insert new records in a table.
- Table datasheet view
- Queries
- Forms
- The following can alter table structure
- Table design view
- Queries
- Examples of how a form can be used to improve speed of a secretary’s data entry
- A form can help a secretary by using of form items like list menus or combo box which make it easy for the secretary to enter data.
- A form can be validated to minimize errors as the secretary is entering the data.
- A form can be used to improve database security by performing data that is sent to the database before it is stored to ensure scripts are not stored in the database.
- MS Access is owned and created by the Microsoft Corporation
- Another DBMS created by Microsoft is AS 400 DB2.
- The name of the database programming language found at the core of MS Access and MS Server is SQL which stands for structured query language.
Buy Itda1001 Database Fundamentals-Database Security Answers Assessment Answers Online
Talk to our expert to get the help with Itda1001 Database Fundamentals-Database Security Answers Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
