Individuals or employers may want to store, view, manage, share information about their personal properties e.g., belongings-car, smartphone, wallet, glasses with their friend, family members.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Belongings DB

Individuals or employers may want to store, view, manage, share information about their personal properties e.g., belongings-car, smartphone, wallet, glasses with their friend, family members.

It may be related to some tables, e.g., persons, product catalog, purchase, and management.

 

DATABASE DESIGN

1. ER Model (Diagram)
2. Data Dictionary table List table name, attribute name and type, description, primary key/foreign key, reference table, etc.
3. ER Model Components List the relationship and cardinality between entities
4. Normalization (1NF, 2NF, 3NF)

 

DATABASE IMPLEMENTATION

1. Table structure (include CREATE, DESC)
2. All data from tables (include INSERT, SELECT * FROM tablename)
3. Database Maintenance

Add a new row

Update old data

Delete data

 

QUERYING RESULTS

 Samples of data maintenance performed on the table. Queries based on a single table (5 queries)

Samples of queries into your database to show its retrieval power Queries based on the multiple tables (10 quires )

SUMMARY/CONCLUSION

 BIBLIOGRAPHY LIST

Attachments:

Expert's Answer

802 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of