Lush Database Design: Assignment

Added on - 17 Oct 2019

  • 19

    Pages

  • 1636

    Words

  • 176

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 19 pages
[ LUSH DATABASE DESIGN ]Student Name:Student ID:Course Name:Course ID:Faculty Name:University Name:
1ContentsLIST OF BUSINESS RULES.........................................................................................................2ER DIAGRAM................................................................................................................................3ENTITIES AND THEIR CHARACTERISTICS:...........................................................................3DATA DICTIONARY....................................................................................................................4DATABASE DESIGN & TABLE STRUCTURE..........................................................................5NORMALIZATION........................................................................................................................7Sql Code...........................................................................................................................................7CREATE & INSERT COMMANDS..........................................................................................7ALL REPORT GENERATED QUERIES................................................................................10Database Implementation..............................................................................................................122.1..............................................................................................................................................122.2..............................................................................................................................................122.3..............................................................................................................................................15
2LIST OF BUSINESS RULES1)Each items has quantities. There can be more than one item for one type of item.2)Regular student’s details are stored in database.3)If student id is not available then student driving licensing number will be stored.4)Student can hire more than one item at a time and each time student hire items the hiringdate and return date is stored in database and the initial charges will be imposed tostudent and these details are saved into database.5)When student will return the item then the status of the item will be saved into databaseand it will checked there is any fine or not and final payment will be taken from student.
3ER DIAGRAMENTITIES AND THEIR CHARACTERISTICS:StudentThis table is used to store the student data uniquely. A unique studentidis declared ofinteger type, this is unique because this is declared as primary key. This id never be null.If the student id is not available then there is one another column “driving licensenumber” this also declared as unique. The values of this column can be null but cannotbe duplicate so this column value is also used to identify students uniquely.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document