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.

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

Related Questions

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

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. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

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

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