Complete Short Database Management Task (MORGAN)

User Generated

ubzrjbexpbafhgyvat

Computer Science

Grantham Univercity

Description

In this part of term project, you will implement the database which you designed from part II of this term project by using MS ACCESS DBMS.

1. Implement the 3rd normalized tables from your Part II Term Project into Oracle Database.

2. Submit a Word file with all the tables you implemented into the Oracle database. For each table, mark the table name, its attributes, primary key, foreign key(s), and sufficient sample data clearly. I will check the consistency of all these components of tables listed on the word file and in the Oracle database.

Unformatted Attachment Preview

Chenesssa Morgan Databases Managmenent October 27, 2019 The City of Califonia Schools Employee School information School name General information School contact information Address Year built Telephon e Number Conceptual Data Modeling Number of Pupils Personal Information Size Name Number of Staff Employment data Contact information home address Work experienc e telephone Current school Qualificatio ns Degree/certificate /diploma/masters School SchoolGenInfo PK SchoolID PK SchoolID YearBuilt NumberOfstaff ContactInfo NumberOfPupils Address Telephone SchoolName EmploymentDetails PK Employee PK EmployeeName CurrentSchool WorkExperience Name Qualifications ContactInfo HomeAddress Telephone #2 The process of distributing videos in Europe is a very organized activity. Movies are categorized by actors by stating their dates of birth and the country they come from. To increase the ease of distribution the movie titles, the length of the movies as well as the time of production are included on the movie information. These movies are installed on discs which are labeled according to serial numbers and the types of the discs being used. Distribution of the discs is done directly to company stores throughout the continent. Some of the distribution stores are rented to increase the delivery rates to consumers. Store number, the serial number of the discs, the city each store is located as well as their contact information is indicated. For rental stores, the serial numbers, customer number as well as date of distribution is included. The price of each movie is indicated on respective discs. The consumer number, name and contact information of the consumer are recorded and stored by the company carrying out distribution. Data is collected from the consumers and retailers to maintain record of buyer data for future marketing of the business. The type of disc is included because consumers may give particular specification of their preference. Part 1: Conceptual Database schema Actors( name, dateofbith, country) Movie(title, length, prodcutiondate) Disk(serialNumber, moviename, storenumber, price, type ) store(storenumber,Name, country, contact) rentalstore(storenumber,Name, country, contact) Consumer(name, contact) Movie Actor PK PK Name Title DateOfBirth length Country prodcutionDate Store storeNum PK Name Country Contact type Consumer Name PK Contact address Disk PK Serial Number movieName storeNumber type price Part 2: Logical and physical database design Actor Name Morgan Freeman James Cameron disk SerialNo 12000 120001 Store DateOfBirth Country 1967 1950 USA USA Name StoreNumber Price type The Avengers The Answer 1222-122 1222-123 $23 $56 DVD DVCD Storenum Name Country contact type 1222-123 London Movie Store London Movies London 122323 Lonodn Streat 122323 Lonodn Streat Rental 1222-122 Manchester Permanent Movie Title length prodcutionDate The Avengers 120 12/12/1980 The Answer 90 12/12/1980 Consumer Name Contact Morgan Kennedy JM Street Phylis Young Morgan Street Revised ER diagram Actor Movie PK Name Store PK Title DateOfBirth PK storeNum length Country Name prodcutionDate Country Contact Consumer type PK Name CustomerID Contact Disk address sales PK salesid PK Serial Number movieName Serial Number storeNumber customerid type price CREATE TABLE ot.disk( serialNumber NUMBER GENERATED BY DEFAULT AS IDENTITY, movieName VARCHAR2(50) NOT NULL, storeNumber VARCHAR2(50) NOT NULL, type VARCHAR2(50) NOT NULL, price VARCHAR2(50) NOT NULL, PRIMARY KEY(salesid) ); CREATE TABLE ot.customer( customerName NUMBER GENERATED BY DEFAULT AS IDENTITY, custmerID VARCHAR2(50) NOT NULL, contact VARCHAR2(50) NOT NULL, address VARCHAR2(50) NOT NULL, PRIMARY KEY(customerid) ); CREATE TABLE ot.sales( salesid NUMBER GENERATED BY DEFAULT AS IDENTITY, diskserialNumberVARCHAR2(50) NOT NULL, customerID VARCHAR2(50) NOT NULL, CONSTRAINT salescust FOREIGN KEY (customerid) REFERENCES customer (customerID) PRIMARY KEY(salesid) ); CREATE TABLE ot.store( serialNumber NUMBER GENERATED BY DEFAULT AS IDENTITY, storeName VARCHAR2(50) NOT NULL, country VARCHAR2(50) NOT NULL, contact VARCHAR2(50) NOT NULL, type VARCHAR2(50) NOT NULL, PRIMARY KEY(serialNumber) ); CREATE TABLE ot.actor ( name NUMBER GENERATED BY DEFAULT AS IDENTITY, dob VARCHAR2(50) NOT NULL, country VARCHAR2(50) NOT NULL, PRIMARY KEY(name) ); CREATE TABLE ot.movie( title NUMBER GENERATED BY DEFAULT AS IDENTITY, length VARCHAR2(50) NOT NULL, productionDate VARCHAR2(50) NOT NULL, PRIMARY KEY(title) );
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Data Dictionary
Actors
Name
DateOfBirth
Country

Length
20
200
200

Data type
Varchar
varchar
varchar

Foreign Key

Primary Key
Y

Sample Data
Actors
Name

DateOfBirth

Country

Peter Kenneth

1968

Turkey

Kenkey Young

1959

USA

Disk
Serial
MovieName
Store Num
Price
Type

Length
2...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags