Giter VIP home page Giter VIP logo

database_server_and_client's Introduction

Database_Server_and_Client

Coursework files for Object Oriented Programming Unit undertaken at University of Bristol. Grage Achieved - 70%

Implement create, use, select, join, alter, drop, delete SQL queries and performed data manipulation.

Operating querues include the commands,

<Command>        ::=  <CommandType> ";"
<CommandType>    ::=  <Use> | <Create> | <Drop> | <Alter> | <Insert> | <Select> | <Update> | <Delete> | <Join>
<Use>            ::=  "USE " <DatabaseName>
<Create>         ::=  <CreateDatabase> | <CreateTable>
<CreateDatabase> ::=  "CREATE DATABASE " <DatabaseName>
<CreateTable>    ::=  "CREATE TABLE " <TableName> | "CREATE TABLE " <TableName> "(" <AttributeList> ")"
<Drop>           ::=  "DROP " <Structure> " " <StructureName>
<Structure>      ::=  "DATABASE" | "TABLE"
<Alter>          ::=  "ALTER TABLE " <TableName> " " <AlterationType> " " <AttributeName>
<AlterationType> ::=  "ADD" | "DROP"
<Insert>         ::=  "INSERT INTO " <TableName> " VALUES(" <ValueList> ")"
<ValueList>      ::=  <Value> | <Value> "," <ValueList>
<Value>          ::=  "'" <StringLiteral> "'" | <BooleanLiteral> | <FloatLiteral> | <IntegerLiteral> | "NULL"
<IntegerLiteral> ::=  <DigitSequence> | "-" <DigitSequence> | "+" <DigitSequence> 
<FloatLiteral>   ::=  <DigitSequence> "." <DigitSequence> | "-" <DigitSequence> "." <DigitSequence> | "+" <DigitSequence> "." <DigitSequence>
<BooleanLiteral> ::=  "TRUE" | "FALSE"
<CharLiteral>    ::=  <Space> | <Letter> | <Symbol>
<StringLiteral>  ::=  "" | <CharLiteral> | <CharLiteral> <StringLiteral>
<Select>         ::=  "SELECT " <WildAttribList> " FROM " <TableName> | "SELECT " <WildAttribList> " FROM " <TableName> " WHERE " <Condition> 
<WildAttribList> ::=  <AttributeList> | "*"
<AttributeList>  ::=  <AttributeName> | <AttributeName> "," <AttributeList>
<Condition>      ::=  "(" <Condition> ")AND(" <Condition> ")" | "(" <Condition> ")OR(" <Condition> ")" | <AttributeName> <Operator> <Value>
<Operator>       ::=  "==" | ">" | "<" | ">=" | "<=" | "!=" | " LIKE "
<Update>         ::=  "UPDATE " <TableName> " SET " <NameValueList> " WHERE " <Condition> 
<NameValueList>  ::=  <NameValuePair> | <NameValuePair> "," <NameValueList>
<NameValuePair>  ::=  <AttributeName> "=" <Value>
<Delete>         ::=  "DELETE FROM " <TableName> " WHERE " <Condition>
<Join>           ::=  "JOIN " <TableName> " AND " <TableName> " ON " <AttributeName> " AND " <AttributeName>
<TableName>      ::=  <PlainText>
<ColumnName>     ::=  <PlainText>
<DatabaseName>   ::=  <PlainText>
<AttributeName>  ::=  <PlainText>
<PlainText>      ::=  <Letter> | <Digit> | <Letter> <PlainText> | <Digit> <PlainText>
<DigitSequence>  ::=  <Digit> | <Digit> <DigitSequence>
<Digit>          ::=  "0" | "1" | "2" | "3" | "4" | "5" | "6" | "7" | "8" | "9"
<Uppercase>      ::=  "A" | "B" | "C" | "D" | "E" | "F" | "G" | "H" | "I" | "J" | "K" | "L" | "M" | "N" | "O" | "P" | "Q" | "R" | "S" | "T" | "U" | "V" | "W" | "X" | "Y" | "Z"
<Lowercase>      ::=  "a" | "b" | "c" | "d" | "e" | "f" | "g" | "h" | "i" | "j" | "k" | "l" | "m" | "n" | "o" | "p" | "q" | "r" | "s" | "t" | "u" | "v" | "w" | "x" | "y" | "z"
<Letter>         ::=  <Uppercase> | <Lowercase>
<Symbol>         ::=  "!" | "#" | "$" | "%" | "&" | "(" | ")" | "*" | "+" | "," | "-" | "." | "/" | ":" | ";" | ">" | "=" | "<" | "?" | "@" | "[" | "\" | "]" | "^" | "_" | "`" | "{" | "}" | "~"
<Space>          ::=  " "

database_server_and_client's People

Contributors

lywangj avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.