Question

The account department of a school requires personal details of all the students. Create a table using the design view including the following fields. Admission number, student name, address, phone, birth date , admission date , bus number

Answer 1

Answer:

Tables store information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information. A fitness database could track your daily running log, your inventory of exercise equipment, and the number of high-protein whey milkshakes you down each day, as three separate tables.

Queries let you quickly perform an action on a table. Usually, this action involves retrieving a choice bit of information (like the 10 top-selling food items at Ed’s Roadside Diner or all the purchases you made in a single day). However, you can also use queries to apply changes.

Forms are attractive windows that you create, arrange, and colorize. Forms provide an easy way to view or change the information in a table.

Reports help you print some or all of the information in a table. You can choose where the information appears on the printed page, how it’s grouped and sorted, and how it’s formatted.

Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer.

Modules are files that contain Visual Basic code. You can use this code to do just about anything—from updating 10,000 records to firing off an email.

Access gurus refer to all these database ingredients as objects because you manage them all in essentially the same way. If you want to use a particular object, you add it to your database, give it a name, and then fine-tune it. Later on, you can view your objects, rename them, or delete ones you don’t want anymore.

NOTE

Designing a database is the process of adding and configuring database objects. For those keeping score, an Access database can hold up to 32,768 separate objects.

In this chapter, you’ll consider only the most fundamental type of database object: tables. But first, you need to create a blank database you can work with.

Answer 2

Table Creation for storing Students Personal details:

• Here, we'll establish the "SCHOOL.db" database, the "STUDENT" table, and insert data using the C programming language.
• We are connecting to the database"SCHOOL.db," which will prompt a notice on the screen if the database has not yet been created or if it has not been created in the SQLITE3 database.

• If the database connection is successful, the STUDENT table will automatically be created; if the table has already been formed, it will be dropped and then recreated.
• We created a string that includes CREATE, INSERT, and DROP statements in the code above. Here, we're adding six rows to the STUDENT table. Here, a semicolon is used to separate each statement.

#include <sqlite3.h>

#include <stdio.h>

int main(void)

{

sqlite3 * dbPtr;

char *errMsg = 0;

int rec = sqlite3_open("SCHOOL.db", & dbPtr);

if (rec != SQLITE_OK)

{

printf("Database cannot Opened: %s\n", sqlite3_errmsg(dbPtr));

sqlite3_close(dbPtr);

return 1;

}

char *sql = "DROP TABLE IF EXISTS STUDENT;"

"CREATE TABLE STUDENT(rollNum INT, Name TEXT, DOB INT );"

"INSERT INTO STUDENTS VALUES(1, 'Arvind', '20/03/2002');"

"INSERT INTO STUDENT VALUES(2, 'Amit', '01/02/2001');"

"INSERT INTO STUDENT VALUES(3, 'Shivang', '08/09/2002');"

"INSERT INTO STUDENT VALUES(4, 'RAGHU', '16/10/2022');"

"INSERT INTO STUDENT VALUES(5, 'SACHIN', '12/01/2003');"

"INSERT INTO STUDENT VALUES(6, 'HITEN', '23/04/2002');";

rec = sqlite3_exec(dbPtr, sql, 0, 0, & errMsg);

if (rec != SQLITE_OK ) {

printf("SQL error: %s\n", errMsg);

sqlite3_free(errMsg);

sqlite3_close(dbPtr);

return 1;

}

sqlite3_close(dbPtr);

return 0;

}

Hence, this is the following code for table Creation for storing Students Personal details.

#SPJ1