Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On the first page, create a table in an ER diagram view. List 10 appropriate attributes (always use PascalCare for your attribute identifiers) for one

image text in transcribedimage text in transcribed

On the first page, create a table in an ER diagram view. List 10 appropriate attributes (always use PascalCare for your attribute identifiers) for one database table (assigned to you based on your last name). Use each of the six Oracle SQL data types taught in class at least once. For each attribute listed, specify an appropriate Oracle SQL data type, (always use ALLCAPS for data types) and whether the attribute should allow null values (NULL - all caps) or not allow null values (NOT NULL - all caps). On the second page, show the same table in a table view. Save this Word document with the filename LastName FirstName ISM 310 HW 1.docx and upload it to BbLearn for credit. Last Names A-D: Customer (each record in your table represents a customer) Last Names E-J: University (each record in your table represents a university) Last Names K-N: Song (each record in your table represents a song) Last Names 0 -T: Band (each record in your table represents a band) Last Names U Z: Movie (each record in your table represents a movie) . . [ENTER TABLE NAME HERE] Data Type Attribute Allow Null? Replace Attribute 1, 2, 3, etc. with the identifiers of your 10 attributes in the gray cells Replace Data type 1, 2, 3, etc. with the data types of your 10 attributes in the dark gray cells In the four white empty rows below these, add four records of sample data. [ENTER TABLE NAME HERE] Attribute 1 Data type 1 Attribute 2 Data type 2 Attribute 3 Data type 3 Attribute 4 Data type 4 Attribute 5 Data type 5 Attribute 6 Data type 6 Attribute 7 Data type 7 Attribute 8 Data type 8 Attribute 9 Data type 9 Attribute 10 Data type 10 Points will be lost for: Fields that are far too short. e.g. LastName - VARCHAR(5) Fields that are excessively long. E.g. HourlyRate - NUMBER(15,2) Use of CHAR for variable length fields Use of VARCHAR for fixed length fields Use of integer data types for fields that store currency values Table name and attributes not PascalCase and singular Incorrect data types Failure to include each of the six Oracle SQL data types discussed in class Incorrect use of parentheses after data types (missing parentheses when they are needed or included parentheses when they should not be included) Failure to rename table Failure to put name on top Failure to include 10 attributes Failure to use ALLCAPS for data types Failure to use PascalCase for attribute and table identifiers Incorrect NULL specifications Listing attributes that are not attributes of your assigned entity Listing sample data that does not adhere to your specified data types

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Database Programming

Authors: Chris Fehily

1st Edition

1937842312, 978-1937842314

More Books

Students also viewed these Databases questions

Question

What is long-term debt?

Answered: 1 week ago

Question

What does it mean when we say that a statistic is robust?

Answered: 1 week ago