Create Oracle table with OIDs instead of Primary key
₹600-1500 INR
Closed
Posted over 7 years ago
₹600-1500 INR
Paid on delivery
I will give you ER digram which is basically online music store , you have to complete below points ( script)
• Use OIDs instead of primary keys for all tables
• Use REFs instead of foreign keys for all tables
• Consider using nested tables and varrays to implement compositions (dependent entities)
where appropriate.
• Consider using subtype hierarchy to represent different types of albums (i.e. CDs, vinyl, MP3
and Cassettes) transforming the subtype hierarchy into a single supertype table. Note that the
subtypes overlap (i.e. the same album can be released in different formats).
Consider the implications of your design on data redundancy and complexity of the solution and
justify your design decisions.
We ca perform the database design as per your mentioned requirements.
We are Mumbai based, Technology Consulting company offering spectrum of IT solutions & services. We provide expert Software development services in web technologies.
Presently we are supporting our clients in USA, Middle East and India.
We look forward to work with you on this requirement.