Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started