opfch.blogg.se

Demo sakila database
Demo sakila database







demo sakila database

So this was created in 2006, back in the day when you would physically go to a shop, look at a selection of DVDs on a. The first one represents a column in the database – DBColumn. Instructor Sukila database contains fake data for a DVD rental store. For the purpose of our project we have created two more classes. The classes that provide us with this information are DBConnection, which binds to the database and DBMetaData, which reads the database with the help of the DatabaseMetaData and ResultSet classes of the Java platform.Ģ. We also want the relationships in the database, with the primary and foreign keys. In general we are interested in the names of the tables, the columns in them with column name, column data type and column data size. We have created two classes for connecting to the sakila MySql database and reading the metadata.

demo sakila database demo sakila database

We create several helper classes that will handle the connection to the database and re-creation of the database metadata in a format which we can use to build the DB diagram.ġ. The structure of the Class Diagram Java project.









Demo sakila database