Bonza – tables

Main tables for Bonza (further details below)
• PERSON
• COMPANY
• VENUE
• PRODUCTION TITLE
• REFERENCES

Other tables around these describe:
Notes, Roletypes, Images, Country.

There are also tables to do with those who add to the database and tracking their actions.

Database Summary of Purpose
The database was originally created to list references to different people, films and TV productions. The database has since been refurbished to list companies, and venues as well as references, people, and productions.

Bonza was set up by academics in the Media Studies department of RMIT University as a teaching and learning resource with a view to providing students an opportunity to record their research and make it publicly accessible. It had the added effect of allowing detailed referencing in the production of their online essays (and thereby, hopefully, reducing descriptiveness). The database allowed students to link their bibliographic and production references to entries already recorded in the database.

The main tables all include comments fields that allow the user, and subsequent users, to make comments on the particular person, reference, venue, company, or production.

Full list of Tables

Roletype
The roletype table is used to link with the person and company tables to provide lists for the different kinds of roles people/companies undertake in relation to a production reference.

For example the roletype table enables you to list John Smith as a ‘Gaffer’ within a production title.

If John Smith ran his own production design company, the roletype field allows you to list him as the ‘Owner’ of the company.

John Smith’s production company can be listed as a ‘production company’ within a production title.

Person
Lists name, year and death of birth, roles and activities undertaken by people involved in the film and TV industry.

Comments field allows user to leave an opinion on the person.

FIELDS: First Name, Middle Name, Surname, Other Name, Birth Year, Death Year, Country, Comments, Actor in productions, Crewed in Productions, Title of reference authored, Name of company worked at, Name of cinema involved with, Titles of Reference, Add Note, Add Image

Companies
Lists name, location, comments, and notes about company. Links to people, film/TV productions

FIELDS: Company Name, Town, State, Or State Other, Country, Comments, People, Productions, Reference, Cinemas, Companies, Note, Image

Venue
The venue table lists the name and address of a cinema as well as the building/demolished date of the cinema and the start and end date of the exhibition within the cinema. It also has a seat and screen count.

The venue table allows for links to references about the venue, people involved with the venue, companies involved with the venue.

The venue table has a special link with the production table as it shows the beginning and end dates of when a particular film screened in the venue.

FIELDS: Cinema Name, Address, Date Built, Date Demolished, Date Started, Date Finished, Seats Count, Screens Count, Companies, People, Films Shown, Reference

Production
The production table is where the details for a particular film or TV show is listed.

This table has an listing for Actor and Crew. This allows the user to easily add actor’s within the production whilst also listing what character they played within the production.

FIELDS: Release Title, Copyright Title, Alternative Title, Production Countries, First Release Year, Production Year, Synopsis, Comments, Actors, Crew, Company Roles, Venue, References

References
The goal of the references table is to show all the different kinds of information needed to create a reference to use within an essay. Therefore the table includes details like author, editor, publisher, date cited and site URL.

References table currently allows for 6 different kinds of references to be added – Book, book chapter, journal article, newspaper article, picture, website article. The reference type field lists these.

The reference table has a synopsis and comments field which allows the person adding the reference to summarise what the reference is about (synopsis) and make value judgements on the reference itself (comments).

The reference table links to the different people, productions, and companies mentioned within the reference. SO if a newspaper article mentions a film, the producer of the film, and a few of the actors then these can be linked from the reference record.

FIELDS: Type, Title, Chapter/Web article title, Town, State, State Other, Country, Section, Volume, Issue, Publication Date, Citation Date, Site URL, Page Number, Comments, Synopsis, Authors, Editors, Publisher, Newspaper, Journal, Key People mentioned, Key production titles mentioned, Key Companies mentioned, Key Cinemas mentioned, Key References mentioned, Add Note, Add Image

Advertisements

0 Responses to “Bonza – tables”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




December 2007
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

%d bloggers like this: