i want an expert DB student

Create a database. At this time, the database file must be created by combining your first name and last

name. $($e$.$g$.$ chrisbang.db$)$

Create a student table and a major table within this table.

The student table must include the student name, student number, and major ID column.

The major table must include the major ID and major name.

Please refer to the table below for the column data types in each table.

Student Table

Major Table

Enter three majors in the major table.

Enter $7$ students, including yourself, in the Student table. Student names should not be too simple, such as

A$,$ B$,$ or C$.$ Use pseudonyms that look like real people's names. When entering, seven students must

designate one of the majors ID$|$ entered above as a Foreign Key $($Reference$).$

Save your program as: Fall$2023\_$your$\_$name$\_$quetion

number.py

Screenshots in a Word document

Save your Word document as Fall$2023\_$your$\_$name$\_$quetion number.docx

Submit the Word document, source code, and the databasefile.