comp

Title of Paper

Student’s Name

Course name and number

Instructor’s name

Date submitted

Motown records

Overview of the company

Motown records were founded on January 12, 1959 and soon became another factory of Detroit where automobiles was produced. Motown also tries to assemble down the soul and pop classic music that helps in changing America. Reaching to the height of the civil rights movement, Motown became the black owned, black centered that provide white Americans something which they were not able to get that is joyous, sad, romantic and mad grooving music. Motown records achieved its success in Detroit, Michigan and the company plays a very important role in racial integration of very popular music. Firstly the record label are owned by African American by featuring African American artists who regularly tries to achieve crossover success and puts a lasting effect on the music industry.

Identification of entities

Motown has now owned and distributes more than 45 subsidiary releases in varying genres. Detroit was formed in Los Angeles in the year 1972 and it also remained an independent company since 1988 up till the time when Gordy sold his company to MCA. Now the headquarters of this company is situated in New York City. Universal Motown Records Group owns a subsidiary named Motown Records (Wand, 2003).

Motown was founded by Berry Gordy Jr, when he first started to write songs for local Detroit acts like Jackie Wilson and Matadors. Wilson’s single song Lonely Teardrops which was co-written by Gordy and Roquel Billy Davis became a huge success but Gordy felt that he has not make much money as he deserves from the release of this song and other single song which he wrote for Wilson. He thought of more lucrative end of his business which was producing records and also owning the royalties of the same songs. Gordy wanted to name their company as Tammy records after a very popular song from his film, Tammy and the Bachelor. When he founded this he was already using it so he decided to use the name Tamla.

Database Application

The whole company is organized into various departments and each and every department owns a unique name, a unique number and also an employee who manages the whole department. They try to keep the track of the start date when the employee tries to manage the department. A department is also situated in several locations. A department also tries to control various projects, and each of the projects has their own unique number, a unique name in a single location.

In the database each employee’s name, their social security number, address, salary, sex and date of birth is stored. An employee is assigned a department but at the same time he can work on various other projects also which is not at all necessary to be controlled by same department as well. A proper track has to be maintained of number of hours on per week basis which records the employee’s work done on each project. A proper track has to be maintained of direct supervisor of each employee.

Motown can also keep a track of the dependents of each employee for the purpose of insurance. Here each dependents first name, sex, date of birth and relationship to the employee has to be maintained.

Conceptual Data Model

A conceptual data model of Motown records is based on the summary level data that is very often used in strategic data projects. It also describes the entire enterprise. Since it is of a very abstract nature so it is referred as conceptual model

Characteristics of conceptual data model:-

The business concepts are covered enterprise wide on the basis of customer, product, store, location and asset

It is designed and developed mainly for business audience

It contains around 20-50 entities with a limited number of attributes described. Sometimes it is limited to only one page

It also contains the relationship between entities but can or cannot include cardinality and null ability

Different entities have different definitions

It is designed and developed to be independent of DBMS that stores locations of data and technologies. It also addresses digital and non-digital concepts. It tries to model paper records and also artifacts (Slater, 2017).

References

Gemino, A.; Wand, Y. (2003). "Evaluating modeling techniques based on models of learning". Communications of the ACM. 46 (10): 79–84. doi:10.1145/944217.944243. Retrieved October 25, 2017

 Mental Representation:The Computational Theory of Mind, Stanford Encyclopedia of Philosophy, [1]. Retrieved October 25, 2017

 Mental Models and Usability, Depaul University, Cognitive Psychology 404, Nov, 15, 1999, Mary Jo Davidson, Laura Dove, Julie Weltz, [2]. Retrieved October 25, 2017

 Slater, Matthew H.; Yudell, Zanja, eds. (2017). Metaphysics and the Philosophy of Science: New Essays. Oxford; New York: Oxford University Press. p. 127. ISBN 9780199363209. OCLC  956947667 . Retrieved October 25, 2017