COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following operations on a database is a database creation?
A
Create a table of student information including:Full name, date of birth, place of birth, gender, address, grade. Binding points between 0 and 10
B
New transfer student Ngo Ngoc Ha has been added to the school
C
Sort the list of students by block, in each block by class, in class in ascending order by name
D
Detect and disallow student access to edit grades in the database
Explanation: 

Detailed explanation-1: -You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source-such as a Microsoft Excel workbook, a Microsoft Word document, a text file, or another database.

Detailed explanation-2: -The CREATE TABLE statement is used to create a new table in a database.

Detailed explanation-3: -Determine the purpose of your database. Find and organize the information required. Divide the information into tables. Turn information items into columns. Specify primary keys. Set up the table relationships. Refine your design. Apply the normalization rules.

There is 1 question to complete.