logo

Lush Database Design: Assignment

19 Pages1636 Words293 Views
   

Added on  2019-10-18

Lush Database Design: Assignment

   Added on 2019-10-18

ShareRelated Documents
[ LUSH DATABASE DESIGN ]Student Name: Student ID: Course Name: Course ID:Faculty Name: University Name:
Lush Database Design: Assignment_1
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
Lush Database Design: Assignment_2
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.
Lush Database Design: Assignment_3
3ER DIAGRAMENTITIES AND THEIR CHARACTERISTICS: StudentThis table is used to store the student data uniquely. A unique student id is declared of integer 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 license number” this also declared as unique. The values of this column can be null but cannot be duplicate so this column value is also used to identify students uniquely.
Lush Database Design: Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Term Project ERD
|7
|684
|295

Data Modelling & Data Base | Project Report
|4
|636
|13

Rationale & Assumption
|11
|1212
|460

Database Design and Implementation for Fashion Outlet
|33
|5708
|93

Southern Cross University Assignment
|19
|1766
|15

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
|7
|800
|134