DBMS/Tables.py at main · TechnicalGeeks/DBMS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
#  Here all the Tables Schema are defined and executed
import sqlite3
conn = sqlite3.connect("Attendacne.db")

def Student():
    print("Successfulyy estabilished Connection ... ")

    # Enter Table Schema below
    conn.execute("""
                Craete Table Student (
                s_id number Primary key ,
                name varchar2(20),
                class number,
                mobile number(10),
                address varchar(50),
                 );""")


    return "Successfully created table"

def Attendace():
    print("Successfulyy estabilished Connection ... ")
    conn.execute("""
                Craete Table Attendance (

                 );""")


    return "Successfully created table"

def Subject():
    print("Successfulyy estabilished Connection ... ")
    conn.execute("""
                Craete Table Subject (

                 );""")

    return "Successfully created table"

def Lecture_count():
    print("Successfulyy estabilished Connection ... ")
    conn.execute("""
                Craete Table Student (

                 );""")

    return "Successfully created table"

def  Year_division():
    print("Successfulyy estabilished Connection ... ")
    conn.execute("""
                Craete Table Student (
                s_id number Primary key ,
                name varchar2(20),
                class number,
                mobile number(10),
                address varchar(50),
                 );""")

    return "Successfully created table"

if __name__ == '__main__':
    choice=0
    while(choice!=9):
        print("1.Student Table")
        print("2.Attendance Table")
        print("3.Subject Table")
        print("4.Lecture Count Table")
        print("5.Year-Division Table")
        print("6.Administrator Table")
        choice =int(input("\nEnter Choice : "))

        if choice == 1:

            pass
        elif choice==2:
            pass
        elif  choice==3:
            pass
        elif  choice==4:
            pass
        else :
            pass